Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bobbydave
Creator III
Creator III

CSV dates

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?

 

Labels (2)
1 Solution
5 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

>>I took a few lines out to show you.
Please do so.
Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
bobbydave
Creator III
Creator III
Author

I never originally attached the file

It originally comes to me in CSV format

bobbydave
Creator III
Creator III
Author

I see nothing?
bobbydave
Creator III
Creator III
Author

Same data attached.

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