ANNIVERSARY_DATE

Calculates and returns the date of a chosen anniversary supplied in the second argument, based on the original date in the first field.

ANNIVERSARY_DATE ( <date_field or date> [, <anniversary number>] )

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

  • anniversary number: The number of years to add to calculate the anniversary. Leaving this as null will default to the first anniversary.

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 calculates the date of the customers 50th Birthday.

ANNIVERSARY_DATE( [CUSTOMER.DATE OF BIRTH] , 50 )

Result:

  • Returns 02/02/2027 for a birthdate of 02/02/1977
  • Returns 09/12/2011 for a birthdate of 09/12/1961
  • Returns 21/01/2046 for a birthdate of 21/01/1996