Date Conversion

[Anonymous]

i have date in Oct-2017 format and want to convert it in to year like 2017

please suggest the way to do this

[sunny_talwar]

Try this

Year(Date#(DateField, 'MMM-YYYY')) as Year

or this

Right(DateField, 4) as Year