Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all fellow Qlik users,
I am just starting my journey with Qlik, and have a question regarding date formats when loading from a CSV file where they are stored as a String. Is this possible to convert from the string format to a date format (ideally dd-mm-yy).
Any guidance given will be gratefully received.
Thanks
Hi
Yes. try below
Date(Date#(YourDateField,'YYYYMMDD'),'DD/MM/YYYY') as Orderdate
Date(Date#(YourDateField,'InputCSVDateformat'),'Outputformat') as Orderdate
Thank you for your support. This solution worked perfectly for me.
Hi
Yes. try below
Date(Date#(YourDateField,'YYYYMMDD'),'DD/MM/YYYY') as Orderdate
Date(Date#(YourDateField,'InputCSVDateformat'),'Outputformat') as Orderdate
Thank you for your support. This solution worked perfectly for me.