Year Function

Returns a whole number representing the year.

Year(date)

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

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.

Date Function

Day Function

Month Function

Now Function

Weekday Function

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions