Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
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
I never originally attached the file
It originally comes to me in CSV format
Same data attached.
Originally in CSV format but the ###### is still in the same format once saved as XLSX