Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns a numeric value that represents the year of the specified date in the Gregorian calendar.
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, look into our Office Cloud Storage Partner Program.
Syntax
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. |
Remarks
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.