Loading
Sales Performance Management
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            end_of_day

            You are here:

            1. Salesforce Help
            2. Docs
            3. Sales Performance Management

            end_of_day

            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))

            See Also

             
            Loading
            Salesforce Help | Article