In a formula-type column, the DAY_DELTA_TODAY() function calculates the difference, in days, between today's date and a date-type column.
-
Function name:
DAY_DELTA_TODAY()
Syntax
DAY_DELTA_TODAY(date_column)
How to call function parameters in TimeTonic:
- $field_name = field (link, linked table column, number, selection, formula, text...).
- "free text" = free text to add within quotes.
- do not use quotes for numbers.
Parameters
| Parameter | Description |
|---|---|
date_column |
The date-type column to compare to today's date. |
Example
DAY_DELTA_TODAY($Date)
The column returns the number of days difference between today and the specified date.
Today is April 8, 2022.
For project 2, there is a 12 day difference between today and the Date column.
Notes
- The calculation is based on today's date: the result automatically updates over time.
Return Type
The function returns a number (the difference expressed in days).
The output type format can be configured in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.
Business Use Case
DAY_DELTA_TODAY() measures age or delay in days relative to today: ticket age, days remaining before a deadline.
Best Practice
Combine DAY_DELTA_TODAY() with TERNARY CONDITION() to automatically flag delays (negative results) or upcoming deadlines.