Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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