Table of Contents

Date Equation Settings

Sarto Jama Updated by Sarto Jama

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

To enable date calculations, update the “Equation Type” to “Date”. 

  • Equation Type: Defines the type of data the equation with be using, either numbers or dates.
  • Date Type: The date type 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, you will be adding 5 hours.
  • 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.

Depending on your Result Type setting different options exist for your results.

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 than 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 rounds 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: 06/04/2013 M D, yyyy: July 4th, 2013 dd/mm/yyyy: 04/06/2013 Ignore Date: no date will be displayed
  • Time Format: This determines how times will be formatted.

How did we do?

Validation Rules

Numeric Equation Settings

Contact