AGEAT

Returns the age in years from the value supplied in the first argument to the value supplied in the second argument.

AGEAT ( <date_field> , <date_field or date> )

• date_field: The date field to use in the calculation.

• date_field or date: The date field or value to use as the point in time.

Example: Create a field on the CUSTOMER table that shows how old each customer was when they made their first purchase.

AGEAT( [CUSTOMER.DATE OF BIRTH] ,[CUSTOMER.FIRST PURCHASE DATE] )