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 | Access 2016

Note Note

The cloud storage feature described in this article is no longer supported in Office 2013 and Office 2016 and may result in the following error:

Sorry, we’re having server problems, so we can’t add <service> right now. Please try again later.

For cloud storage for Office Online, Office for iOS, and Office for Android, you can look into our Office Cloud Storage Partner Program.

Year(Date)

The Year function contains the following arguments.

Argument name

Description

Date

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.

Show: