Mix Dates

[bobbydave]

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? 

[bobbydave]

App attached

[marcus_sommer · Accepted solution]

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

[bobbydave]

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