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")`]