Last updated: August 26, 2026.
The Year function returns the four-digit year component of a date.
Syntax
Year(date)| Argument | Description |
|---|---|
date | Date expression |
Examples
Year(#8/26/2026#) ' 2026
OrderYear: Year([OrderDate])
CurrentYear: Year(Date())A Null date returns Null. For grouping large datasets by year, consider filtering by a date range so an index on the date column can be used.
See Microsoft’s Access function reference for related expression functions.
