Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bobbydave
Creator III
Creator III

Mix Dates

I have two columns that are coming from a CSV. I've converted to XLSX (simple save as).

I bring these into QlikView and the dates are all mixed with text and dates are converted in to the future. What it seems is that it is showing as MM/DD instead of DD/MM.

 

Anyone help with the mix of dates? 

Labels (1)
1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

Just load your data from the csv - it avoids the risks that Excel interpretes the data wrongly (which is rather the rule as the exception).

- Marcus

View solution in original post

3 Replies
bobbydave
Creator III
Creator III
Author

App attached

marcus_sommer
MVP & Luminary
MVP & Luminary

Just load your data from the csv - it avoids the risks that Excel interpretes the data wrongly (which is rather the rule as the exception).

- Marcus

View solution in original post

bobbydave
Creator III
Creator III
Author

And that was exactly it Marcus.
Sometimes the simplest resolution is the answer