See Also
Returns a whole number representing the year.
Year(date) The date argument is any expression that can represent a date. If date contains Null, Null is returned.
The date argument is any expression that can represent a date. If date contains Null, Null is returned.
The following example uses the Year function to obtain the year from a specified date: Dim MyDate, MyYear MyDate = #October 19, 1962# ' Assign a date. MyYear = Year(MyDate) ' MyYear contains 1962.
Dim MyDate, MyYear MyDate = #October 19, 1962# ' Assign a date. MyYear = Year(MyDate) ' MyYear contains 1962.