Corruption Importing date format

[rakeshshah]

Hi All

I am having issues importing from a CSV file - when I use the date# and date functions on load it appears to be modifying the date's month.

First Image is the original file opened in Notepad++ - i have highlighted the bit in questions - clearly a February Month

Second image is the import line i have in Qlik

Third image is the resulting field in Qlik sheet - changed to December

if it helps I am running the latest version of Qlik Sense Desktop 3.2 SR2 (10.18.3)

Looking for help with what im doing wrong

Thanks

Rakesh

[rakeshshah]

Hi Andrey,

Thanks - I don't have Qlik View so can't see this - only Qlik Sense.

Thank you everyone for your help!

The following worked

timestamp(Timestamp#(@38,'YYYY/MM/DD hh:mm:ss'),'YYYY/MM/DD hh:mm:ss') as Rebuilt,

Didn't seem to be a need for the PurgeChar

Rakesh

[ahaahaaha]

Hi Rakesh

In attached file example for Qlik Sence. I am very glad that our colleagues could help you. All the best.

Regards,

Andrey

[rakeshshah]

thank you