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.
Example: Show the numeric value of the day in a given date.
DAYOFYEAR('16/02/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.