topic Re: Mix Dates in QlikView

Mix Dates

bobbydave — Sat, 16 Nov 2024 21:16:28 GMT

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?

Re: Mix Dates

bobbydave — Mon, 11 Mar 2019 09:38:29 GMT

App attached

Re: Mix Dates

marcus_sommer — Mon, 11 Mar 2019 09:49:22 GMT

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

Re: Mix Dates

bobbydave — Mon, 11 Mar 2019 11:26:48 GMT

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