Search…
Resources
Related Links
age
To return the number of full years between now and a given date
Use this function to calculate the current number of full years that have passed since a given date.
The most common application is certainly the calculation of the age of a person based on the date of birth, but other uses are also conceivable:
  • depreciation periods
  • previous terms of long-term contracts
  • determination of anniversaries, etc.
The current date is always used for this calculation.

Syntax

age(date)

Return

number

Examples

age(‘Date of Birth’)
Result: Age in years on the current day, starting from the value of the "Date of birth” field.
age(date(1976, 4, 12))
Result: 45 (on May 27, 2021)
Last modified 2mo ago
Export as PDF
Copy link