date format

[dandaanilreddy]

hello Qlik developers,

can someone help me in getting the data format as 'MM-DD-YYYY'. My data format is

20090629

20090630

20090701

20090703

20090706

20090707

[dandaanilreddy]

I resolved this by writing the below format.

date(Date#(datefield,'YYYYMMDD'),'MM/DD/YYYY')

Thanks

Anil

[sunny_talwar]

Try this:

Date(Date#(DateField, 'YYYYMMDD'), 'MM-DD-YYYY') as DateField

or

Date(MakeDate(Left(DateField, 4), Mid(DateField, 5, 2), Right(DateField, 2)), 'MM-DD-YYYY') as DateField

[dandaanilreddy]

Got it thank you

[sunny_talwar]

Great, please close the thread with marking the correct answer