Search…
⌃K
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
  • 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

1
age('Date of Birth')
Result: Age in years on the current day, starting from the value of the Date of birth field.
1
age(date(1976, 4, 12))
Result: 45 (on May 27, 2021)
Last modified 3mo ago