Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

sharadpujari189
New Contributor

Date Conversion

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

please suggest the way to do this

1 Reply

Re: Date Conversion

Try this

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

or this

Right(DateField, 4) as Year

Community Browser