Year()

Year() - Determine the year from a date

Description

The Year() function is used to determine the year from the supplied date variable or formatted string.

Year(date)

Returns a whole number representing the year.

Example

MyYear = Year("1-Apr-64") 'returns 1964