DAYOFYEAR ER function
The DAYOFYEAR function returns an Integer value that represents the number of days between January 1 and the specified date.
Syntax
DAYOFYEAR (date) as Integer
Arguments
date: Date
A date value that represents the date to use for the calculation of the number of days.
Return values
Integer
The resulting numeric value.
Example 1
DAYOFYEAR (DATEVALUE ("01-03-2016", "dd-MM-yyyy")) returns 61.
Example 2
DAYOFYEAR (DATEVALUE ("01-01-2016", "dd-MM-yyyy")) returns 1.