The following MDX functions are useful for calculations based on date measures.
DateDiff
DatePart
DateRoll
FormatDate
GetFirstDate
GetLastDate
ToDate
ToDateEx
Today
The following calculation functions are useful for calculations based on date measures.
@DATEDIFF
@DATEPART
@DATEROLL
@FORMATDATE
@TODATEEX
@TODAY
The DATEFORMAT Report Writer command.
For information about these functions and commands, see the Oracle Essbase Technical Reference.