MonthEndDate

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

Syntax

MonthEndDate(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-31.