Date Formula
What is a Date Formula?
Date Formula Fields contain automatically generated values based on a defined formula.
A Date Formula field can use the following fields as reference values from within the source Data Table as well as from connected Data Tables:
- Date Fields
- Date/Time Fields
Field Options
Name
This setting allows you to name your Date Formula field. For instance, "Total Time" or Total Hours".
Description
This setting allows you to optionally provide a brief description of this field for your own reference.
Display Output
This setting allows you to select the display output for your Date Formula field. For instance, if you are creating a date formula field to track the total hours of each employee's work day, you would choose Hour as the display output. Output options include:
-
Day
- {End Date} - {Start Date} = 1.00 Day
-
Hour
- {End Date} - {Start Date} = 24.00 Hours
- {End Date} - {Start Date} = 24:00 (HH:mm)
- {End Date} - {Start Date} = 24:00:00 (HH:mm:ss)
-
Second
- {End Date} - {Start Date} = 86400 Seconds
-
Date
- 01/01/2023 + 5 days = 01/05/2023
Adding days to a date field will always include the date in the calculation.
For example, 01/01/2023 + 5 days will count 01/01/23 as the first day, and equal 01/05/2023 - not 01/06/2023
Formula
This setting allows you to define your Date Formula by adding fields, operations, and custom text and date values.
For instance, say you have an Hours data table with a Clock In date/time field, a Clock Out date/time field, and a connection field to your employees. Your employees are clocking in and out every day and you would now like to track the Total Hours each employee is working each day. You can accomplish this by creating a Date Formula field titled Total Hours.
Using Field Values
You can add field values as variables for use with other functions within the Date Formula. For example:
Field Title (Type) -> | Due Date (Date) | Reminder Request (Number) | Notification Date (Date Formula) |
Example Values -> | 01/01/2023 | 14 (variable per record) | Due Date - Reminder Request (Date Output) |
Final Output -> | 12/17/2023 |
Using Custom Values
You can add pre-defined custom values, instead of variable values, for use with other functions within the Date Formula. For example:
Field Title (Type) -> | Due Date (Date) | Grace Period (Number) | Final Due Date (Date Formula) |
Example Values -> | 01/01/2023 | 7 (not variable) | Due Date + Grace Period (Date Output) |
Final Output -> | 01/07/2023 |