Returns a number representing the current date on the Essbase computer. The number is the number of seconds elapsed since midnight, January 1, 1970.
Syntax
Today
Notes
The date returned can be used as input to other functions listed in the See Also section.
Example
This query returns today's actual sales for the product Cola in the market California. Today() returns today's date. StrToMbr retrieves the day member represented by the date returned by Today.
SELECT {[Sales]} ON COLUMNS, { StrToMbr( FormatDate( Today(), "Mon dd yyyy") ) } ON ROWS FROM Mysamp.basic;
See Also