The yearEnd() function returns the date of the end of the Fiscal Calendar year based on a date input.
Syntax
yearEnd(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 |
yearEnd("01/01/2025")
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 > yearEnd(today()) |
| Business rules: Notification Subject | Updates are due before{!yearEnd(today()} |
| Metric expression | Initiative__t.Benefit__m.actual__d.timePeriod(yearEnd(Stage_3_Approval_Date__c)) - Initiative__t.Benefit__m.actual__d.timePeriod(yearStart(Stage_3_Approval_Date__c))
|