I am having trouble getting the date from excel into qlikview. There a few threads already, but im having trouble following them. So i have a date field in excel that is formatted the following way:
=DATE(2011, 3, 1)
that equals 3/1/2011, which is different from what i am getting in QV.
how i imported my excel file was by opening the "edit script" screen. then at the bottom i clicked the button called "table files" and added my excel file to the script. that is how i got this code:
LOAD WID,
Date,
Description,
Who,
Number,
Category
FROM
[WorkLog.xls]
(biff, embedded labels, table is Zach$);
Now i think i have to do something to the date at this point. In the report i did change the number type of the Date field to be a date, but that is not the right date.
QV is generally very good at interpreting the dates, because it stores the dates in to integers/decimal points. I mean in your case it should store the date as 40,603 assuming that there is no time and if there is time then it will store 40,603.xxxxxx something like this...
And if QV don't understand the date then it converts it to string. So I would recommend you to convert your Date Field in to Date Format. You can use Date function in the load script.. something like this...
