DAYOFYEAR

DAYOFYEAR returns a number representing the position in the year of the day part of a given date or date field. January 1st returns 1, February 1st returns 32, etc.

DAYOFYEAR(date_field or date)

Date_field or date - The date to be processed or the name of a field containing one.

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: show the numeric value of the day in a given date.

DAYOFYEAR('02/16/1952)

Result: Returns 47

Example: for each Individual, show the numeric value of the day of their birth.

DAYOFYEAR([Individual.Date of Birth])

Result: Returns 1 for those born on January 1st, 156 for those born on July 4th etc.