topic Re: CSV dates in QlikView

CSV dates

bobbydave — Sat, 16 Nov 2024 04:44:05 GMT

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 — Thu, 17 Jan 2019 08:46:04 GMT

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

Colin-Albert — Thu, 17 Jan 2019 09:24:57 GMT

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

bobbydave — Thu, 17 Jan 2019 09:23:23 GMT

I never originally attached the file

It originally comes to me in CSV format

bobbydave — Thu, 17 Jan 2019 09:24:01 GMT

I see nothing?

bobbydave — Thu, 17 Jan 2019 13:26:16 GMT

Same data attached.

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