Skip to main content
Version: I2024.1.3

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