0
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
special termination rights that might be possible after a certain term (e.g. real estate loan)
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)
Reply
Content aside
Related Articles