Returns the end date for a date-time dimension member.
Syntax
GetLastDate ( member )| Parameter | Description |
|---|---|
member | A member from a date-time tagged dimension. |
Notes
This function returns #MISSING if the input member is not from a date hierarchy in a Time-Date tagged dimension.
The return value is a number representing the input date. The number is the number of seconds elapsed since midnight, January 1, 1970.
This function is applicable only to aggregate storage databases.
Example
The following query returns sales for the last week of April, 2004.
SELECT
{[Sales]}
ON COLUMNS,
{DateToMember(
GetLastDate ([Apr 2004]),
[Time dimension].Dimension,
[Time dimension].[Weeks]
)}
ON ROWS
FROM MySamp.basic;