MonthEndDate

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

Syntax

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

MonthEndDate('2024-07-29') = 2024-07-31

MonthEndDate('2024-07-29 02:00:00') = 2024-07-31