DateTimeToString (Reserved_Word)

image\trumpet2.gif Disclaimer

This reserved word returns a string expression representing the specified DateTime value.

DateTimeToString(dDateTime);

Where dDateTime is a double-precision decimal expression that represents the combination of a Julian date value (using December 30, 1899 as day 0) and a fraction that represents the time (using midnight as time 0).

Remarks

If a specific date is entered for the numeric expression, it must be a valid Julian date between December 30, 1899 and February 28, 2150, expressed in DateTime format.

Examples

strVar = DateTimeToString(45161.61200);  returns a value of "8/23/2023 2:41:17 PM" for the specified DateTime of 45161.61200.

See Also

DateTime (class)