Skip to main content
Version: I2024.1.3

MonthEndDate

Returns a date representing the last day of the Gregorian calendar month in which the input date occurs.

Syntax

MonthEndDate(Date)

Parameters

Date
The date to to return the month end date for.

Example

The following example returns the last day of the month in which 2008-04-10 occurred:

[DateCustom].[Retail445].[Reporting Day].&[`MonthEndDate("2008-04-10T15:30:12")`]