Year Function (Access custom web app)

Office 2013 and later

Returns a numeric value that represents the year of the specified date in the Gregorian calendar.

Last modified: March 09, 2015

Applies to: Access 2013 | Office 2013


The Year function contains the following arguments.

Argument name



An expression that can be resolved to a Date/Time value. The Date argument expression, column expression, user-defined variable or string literal.

Values returned by the Year, Month, and Day functions will be Gregorian values regardless of the display format for the supplied date value. For example, if the display format of the supplied date uses the Hijri calendar, the returned values for the Year, Month, and Day functions will be values associated with the equivalent Gregorian date.