Discussion Board for collaboration on QlikView Scripting.
I was hoping to load with date between . i.e
where Date(APPLIED_DATE,'yyyy/MM/dd') >= '2010/01/01' and Date(APPLIED_DATE,'yyyy/MM/dd') <= '2012/31/01' ;
Please help with the syntax. Thanks
Go to Solution.
Try like this
Load * from tableName where Date(APPLIED_DATE,'YYYY/MM/DD') >= Date#('2010/01/01','YYYY/MM/DD') and Date(APPLIED_DATE,'YYYY/MM/DD') <= Date#('2012/31/01', 'YYYY/MM/DD');
Can you say applied date is in correct format for date? try with date#() also once. May be format is incorrect.
Thanks a lot Mayil it worked just fine.