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.
Additional resources
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for