Date format switches after concatenating 2 files after upload

[Romainscho1]

 Hello everybody,

I tried to call Qlik sense support, but no one ever answers there. Submitting a case for Qlik Business is not available either, so I try my luck here.

We have 2 same excel files, with 2 different dates: mai and june extracted from our databse:

Both times, excel sheets have the same date format. When I upload 2 files into qlik (I tried to upload mai and june first, with same result) the first excel has the good format date (DD.MM.YY). After uploading the second file with same format, the format date switches:

This is very annoying since I can't use the date picker:

How can I solve this issue?

Thx,

[Or]

If you're using Data Load Editor, use either Date(YourField) or date#(YourField,'DD.MM.YYYY') as appropriate. If you're using Data Manager, try changing the field's type manually, or if that doesn't work, add a calculated field with one of the date functions as appropriate.

[anthonyj]

Along with @Or 's answer using the date# function, if you want the '.' separated format update the SET variables in the Main of your script:

SET DateFormat='DD.MM.YYYY';

Regards

Anthony

[Romainscho1]

Hi, 

Thank you for your feedback. I understand what you are saying, but unfortunately I am not used to work with functions 🙂 While trying to add a calculated field using the above mentioned function, I get this:

What am I missing here?

Thank you, 

[Romainscho1]

I tried to switch the format in the load editor too:

Unfortunataly, it did not switch the date format for the 2nd month...