Definition
The YEAR() function returns the year part for a specified date.
Syntax
YEAR(date)
where date is required and it is the date to extract the year from.
Example(s)
What to use in Custom SQL field:
YEAR(GETDATE())
YEAR([Assignment: Actual End Date])
Field Outputs:
