Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
App attached
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