Date Calculation
Date calculations are added in SuperTables 5.4.0. They allow you to do powerful calculations based on date fields and number fields. You can calculate with either dates and/or numbers combined.
Examples:
DATE(Order Date) - DATE(Delivery Date)
Or when using a number:
DATE(Order Date) + (SUM(Nr of Shipping Days) * DAY())
Numbers are by default in seconds. Therefore we added multiple helpers:
Step 1: Open Configuration
This can be done by clicking your the container that has super tables on your dashboard.

Step 2: Navigate to the Data tab

Step 3: Make a Calculation Column
On the left side of the data tab. There is pane that says calculation. Click make a calculation on there.

Step 4: Navigate to the Calculation Box
Navigate to the box that contains Calculation and set the Column Display type to 'Date'

Step 5: Write a calculation like this
You can also use InputTables columns to calculate with date fields. For a dynamic updating dates.

Last updated