Crystal Reports for Eclipse Designer Guide

Date-time literal (#…#)

Usage
# alpha-numeric string # 
This operator converts the enclosed alpha-numeric string to a DateTime value. The alpha-numeric should contain a date, a time, or a date and time representation that can be commonly recognized. Many formats are supported.
Examples
#10:10am#
Returns a DateTime value of 10:10:00am.
#Oct. 19, 1999 #
Returns a DateTime value of October 19, 1999 12:00:00am.
#Oct. 19, 1999 10:10am#
Returns a DateTime value of October 19, 1999 10:10:00am.
Comments
If a formula returns a DateTime value, the format of the returned DateTime value is determined by the DateTime formatting applicable to that formula field.



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