Year Function

Syntax:

Year(dateexpr)

Group:

Time/Date

Description: 

Returns the year.

Parameters:

Parameter

Description

dateexpr

 Return the year for this date value. If this value is Null then 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( ).