Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vanderson009
Contributor

Date Format

I have field which contain Year and Month in Text format, I want to convert it into date format.

We have value like 201803 which is in Text format and i want to make it in date format.

Please help.

Thanks,

Villyee

1 Reply
omarbensalem
Esteemed Contributor

Re: Date Format

Date(DATE#(YourField,'YYYYMM'),'YYYY-MM') as NewDateField