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.