Discussion board where members can get started with QlikView.
I am struggling with wrong date value.
I am loading some data from the dBase III+ dbf files with the help of user DSN.
I want to add extra date type field to the table. For this I calculate a date with the help of under written statement
But as soon as I add this to the table date value changed to 30/12/1899 , here I am struggling what to to do I dont know.
I tried some thing but I am failled. I am using under written script in my QVW
ODBC CONNECT TO KLS;
load *; SQL select max(VOU_DAT) as vDat from d:\Dos\Work\jour6 group by year(VOU_DAT),month(VOU_DAT);
load *, $(enDate) as trDate ;
select * from (
select trCod,sum(amt1) as trAmt from (
select HED_COD as trCod, OP_BAL as amt1 from head6
select HED_COD as trCod, sum(amt) as amt1 from jour6 where vou_Dat<=$(aks) group by HED_COD
) as tb1 group by trCod
) as tb2 where trAmt<>0;
Please Help, Thanks In Advance
Go to Solution.
Try enclosing the date in single quotes (to avoid evaluating the division, resulting in zero -> 30/12/1899)
load *, '$(enDate)' as trDate;
Thanks it is working, Thanks a lot and sorry to you mail.