I get data into Excel from SAP BW and I have a problem with the dates in Qlikview. Date is output as MM.YYYY e.g 10.2012 or 4.2013. When i load my files into Qlikview it doesn't recognise these as dates and sorts them incorrectly like this
1.2012
1.2013
2.2012
2.2013
etc etc
I have looked at various posts without success. If someone could explain exactly what code I need and exactly where I should put it in the script. Do I also have to do anything in my listbox etc I would be extremely grateful
The dates are text and certainly qlikview doesn't recognize as date. In your script, you should include the date#() function (converts text to date) on your field, for example:
LOAD
...
Date(Date#(FieldDateAsText, 'M.YYYY')) as FieldDate
...
FROM ...
Where FieldDateAsText, is the field that contents date as text.
