Wednesday, January 12, 2011

Time Conversion in Crystal Reports

Today I noticed a strange action by Crystal Report.
In the software I`ve done preview on a report and the date appeared as "hh:mm:ss dd/mm/yyy"
In the web site using it the date appeared as ".hh:mm:ssAM/PM dd/mm/yyy".
I don`t really know what`s the difference between the two and it change when switching between one another but this can be easily solved by stating the Date type as Custom while making the report:
1. Right click on the DateTime field you wish to present and select "Format Field"
2. In "Date and Time" Tab click "Customize....".
3. On "Date" Tab under DateType parameter select Custom.

This will make sure the date is set the same in both places.


No comments:

Post a Comment