The TODATE command converts date strings to numbers that can be used to extract data output for a specific time period. TODATE converts date strings into the number of seconds elapsed since midnight, January 1, 1970.
Syntax
<TODATE (formatString, dateString)
Parameter | Description |
---|---|
formatString | The date string format, either "mm-dd-yyyy" or "dd-mm-yyyy". |
dateString | The date string. |
Notes
If you specify a date that is earlier than 01-01-1970, this command returns an error.
The latest date supported by this command is 12-31-2037.
Example
<TODATE("dd-mm-yyyy","15-10-2002")
See Also