Date Field Conversion

[Anonymous]

Hi

I have a date field with the data showing as follows: 20180927

I would like to create another 2 fields for Year and Month

Year should be ‘2018’

Month should be ‘Sep’

[sunny_talwar]

May be this

Year(Date#(DateField, 'YYYYMMDD')) as Year,

Month(Date#(DateField, 'YYYYMMDD')) as Month,

[qlikviewwizard]