Imported Excel date is displayed as a number in QV, not a date.
I have read few posts and tried a few things, but nothing has solved my problem.
I have a date function in Excel, like this: =DATE(2011, 2, 22). That then shows up as a 40597 number in QV.
I understand that i can convert that in QV, so i tried this code in QV Date(ExcelDate, 'DD/MM/YYYY') as PeriodDate. Where ExcelDate is the column from excel, and PeriodDate as the new column name.
I've tried to replicate your situation (date(2011,2,22)) in Excel but 'unfortunately' it always comes through as a formatted date in Qlikview? - I'm running v9 SR6 and Excel 2003.
You can try putting the date() function in both the script and/or the front end and as long as your 'Set' at the start of the script is in place you shouldn't need the 'DD/MM/YYYY' after the Excel column as Qv will default the format.
Apologies I can't be more help but hopefully the above will help in some way.
I've tried to replicate your situation (date(2011,2,22)) in Excel but 'unfortunately' it always comes through as a formatted date in Qlikview? - I'm running v9 SR6 and Excel 2003.
You can try putting the date() function in both the script and/or the front end and as long as your 'Set' at the start of the script is in place you shouldn't need the 'DD/MM/YYYY' after the Excel column as Qv will default the format.
Apologies I can't be more help but hopefully the above will help in some way.
