YEAR

Returns the year portion of the date supplied.

YEAR ( <date_field or date> )

• date_field or date: The date field to use in the calculation.

Example: Create a field on CUSTOMER table to return the year part of each customer's date of birth.

YEAR([CUSTOMER.DATE OF BIRTH] )