Convert Excel String to Date when loading file

[David_K]

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

[Chanty4u · Accepted solution]

Hi 

Yes. try below

     Date(Date#(YourDateField,'YYYYMMDD'),'DD/MM/YYYY') as Orderdate 

Date(Date#(YourDateField,'InputCSVDateformat'),'Outputformat') as Orderdate 

[David_K · Accepted solution]

Thank you for your support.  This solution worked perfectly for me.