Converted date - month disappears when exported to Excel
I have an application that gets data from two different databases (from QVD files). One of the databases have date format yyyymmdd and I convert it to our standard dd-mm-yyyy. BUT when I export the converted dates to Excel the months disappear, so instead of exporting e.g. 27-01-2013 it exports 27--2013 (both to XP and Win7).
Any ideas ? I enclose a small application for you to play with.
It's only the formatting that doesn't arrive in excel. The numeric date value is still correct. What happened is that you used mm instead of MM for the months. In Qlikview mm means minutes, not months. If you change your date format mask then it will export the formatting correctly too.
It's only the formatting that doesn't arrive in excel. The numeric date value is still correct. What happened is that you used mm instead of MM for the months. In Qlikview mm means minutes, not months. If you change your date format mask then it will export the formatting correctly too.
