Syntax

GetFirstDate ( member )

Parameters

member

A member from a date-time 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 first week of April, 2024.

SELECT 
 {[Sales]}
ON COLUMNS,
 {DateToMember(
     GetFirstDate ([Apr 2024]), 
         [Time dimension].Dimension, 
         [Time dimension].[Weeks]
  )}
ON ROWS
FROM MySamp.basic;