Today

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;