YEAR_DELTA_TODAY ()

In a column of type formula, the function YEAR_DELTA_TODAY () makes it possible to make a subtraction between two columns of type date to display the result in year:

YEAR_DELTA_TODAY = year at time t - year of column

Formula

YEAR_DELTA_TODAY (date column)

See the tips.

Example

YEAR_DELTA_TODAY (Date)

There are 2 years of discrepancies between today and the Date column.