MonthStartDate

Returns the date of the first day of the month in which date or timestamp occurs.

Syntax

MonthStartDate(Date/Time)

Where

Date/Time is the input date or timestamp.

For information on the syntax used in your specific database, refer to the Functions Reference.

Example

MonthStartDate('2024-07-29') = 2024-07-01

MonthStartDate('2024-07-29 02:00:00') = 2024-07-01