Loading
Salesforce now sends email only from verified domains. Read More
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
            datevalue

            You are here:

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

            datevalue

            Converts a string or object that represents a date or time value into an integer in Salesforce Spiff. The integer represents the elapsed days since December 30, 1899. This function helps you compare date values more easily.

            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

            datevalue(string_or_object)

            Arguments

            Argument Required? Description
            string_or_object Required The string or object that represents a Date or Date & Time value. Strings must be in YYYY-MM-DD format, enclosed in double quotes.

            Example

            Convert the date August 1, 2023.

            =datevalue("2023-08-01")

            This formula returns 45139, the number of days elapsed between December 30, 1899 and August 1, 2023.

             
            Loading
            Salesforce Help | Article