GetLastDay

The MDX GetLastDay function for Essbase returns, for a given date_part, the last day of the time interval for the input date, following a standard Gregorian calendar.

Syntax

GetLastDay ( date, date_part )

Parameters

date

A number representing the input date. The number is the number of seconds elapsed since midnight, January 1, 1970. To retrieve this number, use any of the following functions: Today(), TodateEx(), GetFirstDate(), GetLastDate(), or DateRoll().

Date-Time type attribute properties of a member can also be used to retrieve this number. For example: Product.currentmember.[Intro Date] returns the Introduction or release date for the current product in context. [Cola].[Intro Date] returns the Introduction or release date for the “Cola” product.

date_part

Defined time components of the standard calendar:

DP_YEAR - year of the input date.
DP_QUARTER – quarter of the input date.
DP_MONTH - month of the input date.
DP_WEEK - week of the input date.

Example

Assuming today’s date is April 15 2024:

GetLastDay(Today(), DP_YEAR)

returns the last day of the year, Dec 31 2024.

GetLastDay(Today(), DP_QUARTER)

returns the last day of the quarter, Jun 30 2024.

GetLastDay(Today(), DP_MONTH)

returns the last day of the month, Apr 30 2024.

GetLastDay(Today(), DP_WEEK)

returns the last day of the week, Apr 21 2024.