Year(date)
Returns the year corresponding to date.
See also DatePart and IsLeapYear.
Any date/time value or string convertible to date.
Years less than 100 are interpreted as 20th century values.
When passing a date as a string, make sure it is enclosed in quotes. Otherwise, it is interpreted as a number representation of a date returning, undesired results.