Skip to Content
Former Member
Sep 10, 2010 at 11:34 AM

report displays date field on server as timestamp, despite format


I formatted a date field in my report as 01/03/2009.

This looks ok when testing in Crystal Reports.

On the server the date displays as 01/03/2009 12:00:00 AM.

I really want to get rid of the time, as it doesn't fit in the report.

I noticed that in an older report the field of the same date is typed as timestamp. In this case the server display correctly.

The problem is, I cannot figure out how/why the date is typed differently in the 2 reports, e.g. date vs timestamp.