The monthEnd() function returns the date of the end of the Fiscal Calendar month based on a date input.
Syntax
monthEnd(date)
| Argument | Description |
| date
(required) |
An expression that results in a date value (i.e., a hard-coded date, a reference to a date attribute, or a function that returns a date value). |
Where Available
Available in all places the expression or injected expression icon is visible, as well as within Filter fields on Cards, Tables and List/View sections.
Examples
| Where | Example(s) |
| Business rules: Set Value
Attribute expression |
monthEnd(2025-12-01)
result within a Calendar Months enterprise: 12/31/2025 result within a 4-4-5 Retail Calendar December end enterprise: 01/03/2026 |
| Field Editability expression
Tab Visibility expression |
Due_Date__c > monthEnd(today()) |
| Business rules: Notification Subject | Updates are due before{!monthEnd(today()} |
| Metric expression | Initiative__t.Benefit__m.actual__d.timePeriod(monthEnd(Stage_3_Approval_Date__c)) - Initiative__t.Benefit__m.actual__d.timePeriod(monthStart(Stage_3_Approval_Date__c))
|