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)