Year
Returns the year (AD) corresponding to the specified date.
Syntax
Year(date)Annee(date)
date = date whose year you want to retrieve
Remarks
To obtain the current year, you can use the Now function as the parameter.
Example
Year(Now()) = current year; in 2010, it will return 2010.Year(Now()-10) = year 10 days before the current date; returns 2009 on January 5, 2010, for example.