Day of Year for Date Number [DayOfYearFor#]

Return to Complete List of Functions

The Day of Year for Date Number function determines the day of the year for a date specified as a date number. This is also known as the julian day. Parameters ------------------ Date Number     The number of days between a given date and December 30, 1899.                           This value is typically generated based on the Date As Number function. Function Value ------------------------ This function extracts the day of the year from the date associated with the current record. The resultant value is a number from 1 to 366 where 1 is January 1st.