<< Click to Display Table of Contents >> Navigation:  Date / Time functions > Year

Description

Returns an Integer specifying a whole number representing the year.

Syntax

MyYear = Year(date)

Example

Dim MyDate As Date
Dim MyYear As Integer
MyDate = #May 20, 1963#   ' Assign a date.
MyYear = Year(MyDate)     ' MyYear contains 1963