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.
Note: dates in Audiences need to be formatted as either YYYY-MM-DD or MM/DD/YYYY. Entering a date as 01-02-2023 would be read as Jan-2 not 1-Feb.
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] )