DateToString

Returns a string expression corresponding to the date (integer) portion of the specified DateTime value.

The integer portion of the DateTime value specifies the number of days since January 1st, 1900, and the fractional portion of the DateTime value specifies the fraction of the day since midnight.

Usage

DateToString(DateTime)

Where:

DateTime - a double-precision decimal DateTime value to be converted to a string expression representing the date.

Notes

• The output in the examples below is in the default regional date format of the user. Date format is controlled by the Regional Options settings that can be accessed from the Control Panel of the Windows operating system. Depending on your regional settings your output might differ from the examples below.
• Use FormatDate to have more control over the formatting of the outputted string.

Examples

DateToString(39448.25000000)

Will return the string "1/1/2008".

DateToString(ComputerDateTime)

Will return the string "19-2-2012" for someone with European Regional settings.