Year
Purpose
Returns a whole number representing the year.
Syntax
Year(date)
Description
The date argument is any expression that can represent a date. If date contains Null, then Null is returned.
Example
This example uses the Year function to obtain the year from a specified date:
| Function | Result |
|---|---|
| Year("01 January 2012") | 2012 |