ANNIVERSARY_DAYSTO

Calculates and returns the number of days until a specific anniversary, based on the date supplied in the first argument.

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

date_field or date: 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 PURCHASE table that calculates how many days until the First Anniversary of that Purchase date.

ANNIVERSARY_DAYSTO( [PURCHASE.PURCHASE DATE] , 1 )