Crystal Reports for Eclipse Designer Guide

Converting Date, Time, and DateTime values

Any character, with the exception of the date or time format characters, can be used within the format string. For example, you may wish to use a slash to separate the different elements (month, day, year) of the date, as in "12/30/95", or you may wish to use a colon to separate the different elements (hours, minutes, seconds) of the time, as in "12:30:10".
If you wish to use any of the above characters in the format string, they must appear in quotes. For example:
ToText(DateTime(1995,10,12,13,20,22), "MM/dd/yy hh 'h' mm 'min' ss 'sec' ", 'am', 'pm') = "10/12/95 1 h 20 min 22 sec pm"



SAP BusinessObjects
http://www.sap.com/sapbusinessobjects/
Support services
http://service.sap.com/bosap-support/
Product Documentation on the Web
http://help.sap.com/