YEAR_DELTA_TODAY() : calculate an age from a birth date

In a formula-type column, the YEAR_DELTA_TODAY() function calculates the difference, in years, between today's date and a date-type column, and returns a number. It is used to calculate an age or seniority: a client's age based on their birth date, contract seniority.

For an exact age, check the rounding method. The year difference may not account for the day and month depending on the case.

Syntax

YEAR_DELTA_TODAY(date_column)

Parameters

# Parameter Description

1 date_column The date-type column to compare with today's date.

The calculation is based on today's date: the result therefore updates automatically over time, with no further action needed.

The output format of the column can be chosen in the output field options of the formula editor. For more details, see Output format options in the Formula Column article.

Examples

Calculate a difference in years

YEAR_DELTA_TODAY($Date)

The column returns the number of years difference between today and the given date. For project 3, there is a 3 year difference between today and the Date column.

Go further

MONTH_DELTA

The equivalent in months: calculate the difference between two dates.

Read more →

Or continue with

Formula glossary

All available operators and functions, sorted by category.