Year Function

Syntax

Year(dateexpr)

Group

Time/Date

Description

Returns the year.

Parameters

Parameters Description
dateexpr Returns the year for this date value. If this value is Null, Null is returned.

Example


Sub Main
    Debug.Print Year(#1/1/1900#) ' 1900
    Debug.Print Year(#1/1/2000#) ' 2000
End Sub

See also

Date( ), Day( ), Month( ), Weekday( )