Year

Returns a whole number representing the year.

Structure

Year(date)

Parameters

The date argument is any expression that can represent a date. If date contains Null, Null is returned.

Example

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. |