Show Fraction Second in Crystal 1

[scottm87]

I have a client that has a need to show fractions of a second in Crystal Reports 2008. The field is a Date/Time field in SQL 2008 and I can see the fractions of a second within SQL, but, I cannot get to display in Crystal.

I have never had to do this within Crystal and am not sure if this is even possible, any ideas?

Thanks

Scott

 

[briangriffin]

If you just need to display it, you could use a SQL Expression - this is SQL Server syntax:

convert(varchar(30),datetimefield,121)

That would display correctly in CR, but as a text field.

If you need to perform calculations using milliseconds you could probably use the same technique, depending on the calculation needed:

convert(varchar(30),datetimefield1 - datetimefield2,121)

Regardless, the calculation would have to be done on the database side, then converted to text.

 

[scottm87]

Thank you that did the trick!!!