Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date Field Conversion

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’

2 Replies
sunny_talwar

May be this

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

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

qlikviewwizard
Master II
Master II

Capture.PNG

Capture1.PNG