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.
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)