Returns the last day of the year for a specific date or time value in Salesforce Spiff. The return format is YYYY-MM-DD. If you've specified fiscal year dates that are different from standard calendar dates, use the end_of_fiscal_year() function instead.
Required Editions
| Available in: both Salesforce Classic (not available in all orgs) and Lightning
Experience |
| Available in: Enterprise, Unlimited, and Developer
Editions |
| Available for an additional cost in: Professional Edition with Web
Services API Enabled |
Syntax
end_of_year(date_or_time)
Arguments
| Argument |
Required? |
Description |
| date_or_time |
Required |
The Date or Date & Time value to evaluate. This argument supports any date functions. |
Example
Return the last day of the year based on the current statement period's end date.
=end_of_year(statement_period.end_date)