We’ve upgraded our Equation field type to include date calculations.
Date calculations will allow you to create dynamic equations combining date fields, the current time, and your own time values.
Some common examples of date equations are:
- Calculating age by subtracting birth date from the current time
- Calculating expiration dates by adding days to a start date
- Calculating time spent by subtracting a start date from an end date
How does it work? When you add or edit an Equation field you can determine if it’s a numerical or date type:
Selecting Date will display any eligible date fields you can add to your equation. There’s also a special Current Time field you can use to represent the current time when the calculation is run.
You can control the Date Type. This will convert any numbers used in the equation into the selected date type. In the example below the 30 will add 30 days to the start date since days is selected as the type.
Date Equations are in beta so please let us know if you run into any issues.