Date equations can calculate dates and format results as hours, days, weeks, etc. Activate a date equation by setting the "Equation Type" option to Date.
Date Type: The date type is used to convert any number values in the equation 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 different options exist for your results.
- Result Type: Number
Decimals: Whether large numbers will be separated by commas, decimals, or nothing.
Decimal Places: The amount 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.
Thousands: Whether commas will separate thousands in large numbers. For example, 80000 would display as 80,000.
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.
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.