DayOfYear(Date date)

Returns the number of days by which the given date follows the first day of the year.

Parameters

date

The date to check.

Returns

Numeric

Remarks

If the date value is null, the system returns the numeric value 0.

Examples

• DayOfYear(#2013-01-01#) returns the numeric value 1.
• DayOfYear(#2013-03-20#) returns the numeric value 79.