@TODAY

The @TODAY calculation function for Essbase returns a number representing the current date on the Essbase server 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.
As this function is a run-time formula, you cannot use it in a FIX statement.

Example

If today’s date is 15-Jul-2024, the following expression returns 15:

@DATEPART(@TODAY(), DP_DAY)