Loading
Salesforce now sends email only from verified domains. Read More
Extend Salesforce with Clicks, Not Code
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
            Formula Data Types

            You are here:

            1. Salesforce Help
            2. Docs
            3. Extend Salesforce with Clicks, Not Code

            Formula Data Types

            The data type of a formula determines the type of data you expect returned from your formula.

            Data Type Description
            Checkbox Returns a true or false value. The field appears as a checkbox in record detail pages and reports. Use True for checked values and False for unchecked values.
            Currency

            Returns a number in currency format of up to 18 digits with a currency sign.

            Salesforce uses the round-half-up tie-breaking rule for currency fields. For example, 23.5 becomes 24, 22.5 becomes 23, −22.5 becomes −23, and −23.5 becomes −24.
            Date Returns data that represents a day on the calendar. The current date can be acquired by calling the built-in function TODAY() in a formula. This data type isn’t available for custom summary formulas in reports.
            Date/Time Returns data that represents a moment in time. A date/time field includes the date and also the time of day including hour, minutes, and seconds. You can insert the current date and time in a formula using the NOW() function. This data type isn’t available for custom summary formulas in reports.
            Number Returns a positive or negative integer or decimal of up to 18 digits. Salesforce uses the round half up tie-breaking rule for numbers in formula fields. For example, 12.345 becomes 12.35 and −12.345 becomes −12.35.
            Percent Returns a number in percent format of up to 18 digits followed by a percent sign. Percent data is stored as a decimal divided by 100, which means that 90% is equal to 0.90.
            Text Returns a string of up to 3900 characters. To display text in addition to the formula output, insert that text in quotes. Use the text data type for text, text area, URL, phone, email, address, and auto-number fields. This data type isn’t available for custom summary formulas in reports. Text area isn’t a supported data type.
            Time

            Returns data that represents a moment in time, without the date. A time field includes the time of day by hour, minutes, seconds, and milliseconds. You can insert the current time in a formula using the TIMENOW() function.

            In formula expressions, use the international date format (ISO) for text arguments. For example, use TIMEVALUE("11:30:00.000") instead of TIMEVALUE("11:30 AM").

            See Also

             
            Loading
            Salesforce Help | Article