Example
SELECT Year(#05/17/2017#);Definition and Usage
The Year() function returns the year part of a given date.
This function returns an integer between 100 and 9999.
Syntax
Year(
date
)Parameter Values
| Parameter | Description |
|---|---|
| date | Required. A numeric or string expression that can represent a valid date |
Technical Details
| Works in: | From Access 2000 |
|---|