end_of_period

Returns the last day of the statement period for a specific date or time value in Salesforce Spiff. The return format is YYYY-MM-DD.

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_period(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 statement period for the current day.

=end_of_period(Today)