MonthStartDate
Returns a date representing the first day of the Gregorian calendar month in which the input date occurs.
Syntax
MonthStartDate(Date)
Parameters
Date
The date to return the month start date for.
Example
The following example returns the first day of the month in which 2005-08-15 occurred:
[DateCustom].[StandardMonth].[Month].&[`MonthStartDate("2005-08-15T12:30:10")`]