Description
Returns an integer (1 to 366) corresponding to the sequential day of the year in a datetime or expression.
Syntax
DAYOFYEAR ( date )
| Parameter | Description |
|---|---|
| date | Date (or input field containing a date) to be returned as a day of the year. |
Remarks
The DAYOFYEAR function uses the Gregorian calendar.
Examples
This function returns "365", corresponding to the supplied date:
DAYOFYEAR( "2014-Dec-31" )
However, due to the leap year, this function returns 366:
DAYOFYEAR( "2012-Dec-31" )
If source field S15 contains the date "1/21/2014", the following formula returns "21":
DAYOFYEAR( S15 )
See also