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 |