In a formula-type column, the function WEEK_DELTA_TODAY() calculates the difference, in weeks, between today's date and a date-type column.
-
Function name:
WEEK_DELTA_TODAY()
Syntax
WEEK_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 with today's date. |
Example
WEEK_DELTA_TODAY($Date)
Today is April 8, 2022. For Project 2, there is a 2-week difference between today and the Date column.
Notes
- The calculation corresponds to: week at time t minus week of the column. The result is expressed in weeks.
- The result is based on today's date: it updates automatically over time.
Return Type
The function returns a number (the difference expressed in weeks).
The output type format of the result can be configured in the output field options of the formula editor. For more details, see Output Format Options in the Formula Column article.
Use Case
WEEK_DELTA_TODAY() tracks deadlines in weeks: number of weeks remaining before a deadline, age of a file in weeks, alerts on tasks with approaching deadlines.
Best Practice
Combine WEEK_DELTA_TODAY() with TERNARY CONDITION() to convert the difference into a readable label (for example, “upcoming,” “this week,” “past”).