Year
Returns a whole number representing the year.
Syntax
Year(date)The
date argument is any expression that can represent a date. If
date contains Null, then Null is returned.
Example
This example obtains the year from a specified date and returns 2017:
Year("01 January 2017")