Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

mubz2222
New Contributor

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

Re: Date Field Conversion

May be this

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

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

Arjunarao
Honored Contributor II

Re: Date Field Conversion

Capture.PNG

Capture1.PNG