DayOfYear(x)

This function returns the day of the year for a given date (a number from 1 to 366).

Example:

DAYOFYEAR(“policy_date”)