Share via


DAYOFYEAR (Report Builder 1.0)

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