Share via


YEAR (Report Builder 1.0)

Returns a year value from a datetime.

Syntax

YEAR(datetime)

datetime

Specifies the datetime from which the year is extracted.

Example

Formula

Result

YEAR(Sell End Date)

Returns the numeric value of the sales week for each instance of the Sell Start Date field, similar to the following:

2002

2005

2003

YEAR(#3/31/2008)

2008