The quarterEnd() function returns the date of the end of the Fiscal Calendar quarter based on a date input.
Syntax
quarterEnd(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 |
quarterEnd("01/01/2025")
result within a Calendar Months enterprise: 03/31/2025 result within a 4-4-5 Retail Calendar December end enterprise: 03/29/2025 |
| Field Editability expression
Tab Visibility expression |
Due_Date__c > quarterEnd(today()) |
| Business rules: Notification Subject | Updates are due before{!quarterEnd(today()} |
| Metric expression | Initiative__t.Benefit__m.actual__d.timePeriod(quarterEnd(Stage_3_Approval_Date__c)) - Initiative__t.Benefit__m.actual__d.timePeriod(quarterStart(Stage_3_Approval_Date__c))
|