AGE

Returns the age in years from the value supplied to the current system date.

AGE ( <date_field or date> )

• date_field or date: A date field or value.

Example: Create a field on the CUSTOMER table that shows the current age of each customer.

AGE( [CUSTOMER.DATE OF BIRTH] )