DAYOFYEAR

Syntax

DAYOFYEAR(<date>)

Description

Returns the day of the year for the supplied date in a range from 1 to 366.

Examples

DateDAYOFYEAR Returns

Jan 1, 2018 12:23:05 PM

1

Jun 14, 2018 12:23:05 PM

165

Dec 25, 2018 12:23:05 PM

359