Need help/answers for a date/time field

[stormtrooper]

Hello there. I am using CR9 and I have a field from DB2 in that has a date/time format of 2004-04-20-11.42.06.991822
(yyyy-MM-dd-hh.mm.ss.ms). How do I get crystal to display the whole field and not just up to the ss part?

 

[lbass]

One approach would be to convert it to text:

totext({table.datetime},"yyyy-MM-dd hh.mm.ss.")
+right(totext({table.datetime}),6)

-LB

 

[stormtrooper]

Using the above formula, I get this:

2004-04-20 11.42.06