CSV dates

[bobbydave]

So I have this file. I took a few lines out to show you.

The dates come in as text (General) but some come in as Dates.

The general text are in US MM/DD/YYYY but the Dates come in as DD/MM/YYYYY.

Qlikview doesn't have the functionality to realise which is which.

Anyone come across such an issue. I know the issue is at source but is there a way around changing this so that all come out in DD/MM/YYYY?

[jonathandienst]

>>I took a few lines out to show you.
Please do so.

[Colin-Albert · Accepted solution]

It would help if you can give us some example data.

Here are some useful blogs on dates which should help you.
https://community.qlik.com/t5/Qlik-Design-Blog/Why-don-t-my-dates-work/ba-p/1465849

https://community.qlik.com/t5/Qlik-Design-Blog/Get-the-Dates-Right/ba-p/1476178
https://community.qlik.com/t5/QlikView-Documents/QlikView-Date-fields/ta-p/1484786

[bobbydave]

I never originally attached the file

It originally comes to me in CSV format

[bobbydave]

I see nothing?

[bobbydave]

Same data attached.

Originally in CSV format but the ###### is still in the same format once saved as XLSX