MDX Functions that Return a Date
The following MDX functions return a date, if your Essbase cube is set up to use typed measures, and specifically, date measures.
The functions linked below return a date, from cubes that support date measures. In addition to these functions, other functions help work with date measures as well, including DateToMember (which returns a member), FormatDate (which returns a string), and DateDiff, DatePart, and ToDate (all of which return numbers).
Table 4-32 MDX Date Functions
| Function | Result |
|---|---|
| DateRoll | To the given date, rolls (adds or subtracts) a number of specific time intervals, returning another date. |
| GetFirstDate | Returns the start date for a date-hierarchy member. |
| GetLastDate | Returns the end date for a date-hierarchy member. |
| GetNextDay | To the given date and the week day, gets the next date after input date that corresponds to the week day. |
| GetFirstDay | For a given date_part, returns the first day of the time interval for the input date. |
| GetLastDay | For a given date_part, returns the last day of the time interval for the input date. |
| TodateEx | Converts date strings to dates. |
| Today | Returns a number representing the current date. |
| JulianDate | For the given UNIX date, gets its Julian date. |
| UnixDate | For the given Julian date, gets its UNIX date. |