Catatan
Akses ke halaman ini memerlukan otorisasi. Anda dapat mencoba masuk atau mengubah direktori.
Akses ke halaman ini memerlukan otorisasi. Anda dapat mencoba mengubah direktori.
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)