Returns the last second for a specific date or time value in Salesforce Spiff. The return format is YYYY-MM-DDT:hour:minute:second:millsecond, plus or minus the hours and minutes away from Coordinated Universal Time (UTC).
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_day(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 end of the day that represents the end of the statement period, using the EndOfPeriod helper function.
=beginning_of_day(EndOfPeriod)Find the end of the day from a text-formatted date, which you can convert to a proper Date data type with the date() function.
=end_of_day(date("2024-01-31"))Create a data filter that return all deals created between January 1 and 31. Combine this function with beginning_of_day().
CreatedAt >= beginning_of_day(date("2024-01-01")) AND CreatedAt <= end_of_day(date("2024-01-31"))Update the previous data filter with dynamic statement period dates instead of hard-coded text values.
CreatedAt >= beginning_of_day(date(statement_period.start_date)) AND CreatedAt <= end_of_day(date(statement_period.end_date))