### Date-time literal (#...#)

Basic and Crystal syntax.

##### 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

The following examples are applicable to both Basic and Crystal syntax:

`#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.

###### Related topics

Date, Time, and DateTime under Simple data types (Basic syntax)

Date, Time, and DateTime under Simple data types (Crystal syntax)

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com