TODATE

The TODATE Report Writer command in Essbase 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)

Parameters

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")

ATTRIBUTE

WITHATTR