Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I resolved this by writing the below format.
date(Date#(datefield,'YYYYMMDD'),'MM/DD/YYYY')
Thanks
Anil
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
Got it thank you
Great, please close the thread with marking the correct answer