MonthStartDate

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

Syntax

MonthStartDate(Date/Time)

Where:

Date/Time is the input date or timestamp.

For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions.

Example

Input is the date 2004-07-29; output is the date 2004-07-01.