DAYOFYEAR (Report Builder)
Returns the day of the year of the datetime. January 1st = 1 through December 31st = 366, assuming a leap year.
Syntax
DAYOFYEAR(datetime)
datetime |
Specifies the datetime from which the day of the year (1-366) is extracted. |
Example
| Formula | Result |
|---|---|
DAYOFYEAR(#12/14/2008#) |
349 |
DAYOFYEAR(Start Date) |
Returns a day of the year for each instance of the Start Date field, similar to the following: 122 135 152 |
See Also
Concepts
Working with Formulas (Report Builder)
Using Functions (Report Builder)
Date and Time Functions (Report Builder)
Report Builder How-to Topics
Working with Literals in Formulas and Filters (Report Builder)
Formatting Numerical Data (Report Builder)