Fields
      Back to home
      1. Knowledge Base
      2. Builder Guide
      3. Fields

      Date Equation Settings

      In this article, you can learn about Date Equation field settings.

      Date equations can calculate dates and format results as date values or number values of seconds, hours, days, weeks, or years. 

      To enable date calculations, update the “Equation Type” to “Date” in the field's settings. 

      • Equation Type: This option will be either "Numeric" or "Date". For this article, we're covering Date equations. 

      • Date Type: The date type option is used to convert any number value in the equation to a time unit before being calculated. For example, if you selected "hours" and are adding "5" to a date field value, you would be adding 5 hours.

        The following are the available options:

        • seconds
        • hours
        • days
        • weeks
        • years

      Notes:

      • As of 2026-11-26, you will no longer be able to set the Date Type to "hours" if the result of the equation has the Time Format set to "Ignore Time".

      • By default, Date Equation fields that have "Ignore Time" set will have "Days" selected for the Date Type.

      • Result Type: A Date Equation can return a result either as a date or as a number depending on what you choose for this option.

      settings1

      Note: Depending on your Result Type setting, different options exist for your results. See details below.

       

      Result Type: Number

      • Decimals: Whether large numbers will be separated by commas, decimals, or nothing.

      • Decimal Places: The number of decimal places to include when displaying the number. This doesn't affect how the numbers are stored in the database, only how they are displayed. If the stored number has more decimal places than this option, then the displayed number will be rounded.

      • Rounding: Whether the number should be rounded up or down. If using the default setting, numbers ending in a number below 6 will round down, and anything else will round up.

      • Thousands: Whether commas will separate thousands in large numbers. For example, "80000" would display as "80,000".

      • Number Format: Options to format your number with currency letters or your own custom before and after the text.

       

      Result Type: Date

      • Date Format: This determines how dates will be formatted.

        Here are examples for the date of July 4th, 2013:

        • mm/dd/yyyy: 07/04/2013

        • M D, yyyy: July 4th, 2013

        • dd/mm/yyyy: 04/07/2013

        • Ignore Date: no date will be displayed

      • Time Format: This determines how times will be formatted.

      Tip: To learn about numeric equation settings, see this article here.