Table 202 lists the MDX functions that are provided for analysis of date hierarchies. For a complete description of these functions, see the Oracle Essbase Technical Reference.
Table 202. MDX Functions for Analyzing Date Hierarchies
Function | Description |
---|---|
DateDiff | Returns the difference between two input dates. |
DatePart | Returns the date part (Year/Quarter/Month/Day/DayOfYear/Weekday) as a number. |
DateRoll | To the given date, rolls (adds or subtracts) a number of specific time intervals, returning another date. |
DateToMember | Returns the date-hierarchy member specified by the input date. |
FormatDate | Returns a formatted date-string. |
GetFirstDate | Returns the start date for a date-hierarchy member. |
GetLastDate | Returns the end date for a date-hierarchy member. |
Today | Returns a number representing the current date on the Essbase computer. |
ToDateEx | Converts any date string to a date that can be used in calculations. |