Function: DayOfYear

Description

Returns the day number (1-366) from a date/time.

Syntax

DayOfYear(date)

Arguments

Date can be a constant, a date field, an expression that results in a date, or a function that returns a date.

Return value

This function returns a number. The return value is the day of the year where January 1st=1, January 2nd=2, etc. The range of return values is 1-366, where 366 is possible only in leap years.

Calculated field example

The following expression will return 305 from a Date field containing 11/1/2003 12:05:33 AM: DayOfYear(Date)