end_of_year

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)