GetFirstDay
The MDX GetFirstDay function for Essbase returns, for a given date_part, the first day of the time interval for the input date, following a standard Gregorian calendar.
Syntax
GetFirstDay ( 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:
GetFirstDay(Today(), DP_YEAR)returns the first day of the year, Jan 1 2024.
GetFirstDay(Today(), DP_QUARTER)returns the first day of the quarter, Apr 1 2024.
GetFirstDay(Today(), DP_MONTH)returns the first day of the month, Apr 1 2024.
GetFirstDay(Today(), DP_WEEK)returns the first day of the week, Apr 15 2024.