DAYOFYEAR
DAYOFYEAR
Syntax
DAYOFYEAR(<date>)
Description
Returns the day of the year for the supplied date in a range from 1 to 366.
Examples
Date | DAYOFYEAR 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 |
, multiple selections available,
Related content
DAYOFYEAR
DAYOFYEAR
More like this
WEEKOFYEAR
WEEKOFYEAR
More like this
DAY
More like this
YEAR
YEAR
More like this
ENDOFMONTH
ENDOFMONTH
More like this
WEEKDAY
WEEKDAY
More like this