DATEPART
DATEPART([Created On], 'year')Syntax
DATEPART(date expression, date part)
Function which returns provided date part of date as a number.
date expression: Date calculation created using date functions, data fields or constants.
date part: Text constant which can be chosen from minute, hour, dayofweek, dayofmonth, dayofyear, week, month, quarter, year