StringToDateTime (Reserved_Word)

image\trumpet2.gif Disclaimer

This reserved word returns a double-precision decimal DateTime value representing the specified string expression of the date and time in "MM/DD/YYYY HH:MM:SS TT" format.

StringToDateTime(strDateTime);

Remarks

The specific date must be a valid date between January 1, 1900 and February 28, 2150, expressed in DateTime format.

Examples

Value1 = StringToDateTime("02/01/03 10:12:43 PM");  returns a DateTime value of 37653.93 for the specified date and time.