Skip to main content

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")`]