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
Click on the container that has SuperTables running. This will display an arrow that you can click to open a menu. Upon opening the menu, click the 'Configure...' option to open the configuration panel for SuperTables.
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 calculations, expand that menu and click 'Make a calculation' to create one.
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