Skip to main content

Year function

Table of contents
  1. Syntax
  2. Example

Returns a Variant (Integer) containing a whole number representing the year.



The required date argument is any Variant, numeric expression, string expression, or any combination, that can represent a date. If date contains Null, Null is returned.


This example uses the Year function to obtain the year from a specified date. In the development environment, the date literal is displayed in short date format by using the locale settings of your code.

Dim MyDate, MyYear
MyDate = #February 12, 1969#    ' Assign a date.
MyYear = Year(MyDate)    ' MyYear contains 1969.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>