MDX Functions that Return a Date

The following functions return a date.

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.