topic Re: Load table where date is between in QlikView

Load table where date is between

Anonymous — Fri, 14 Dec 2012 18:39:17 GMT

Hi,

I was hoping to load with date between . i.e

LOAD

FROM dbs

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

Re: Load table where date is between

MayilVahanan — Fri, 14 Dec 2012 18:43:53 GMT

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.

Re: Load table where date is between

Anonymous — Fri, 14 Dec 2012 18:49:09 GMT

Thanks a lot Mayil it worked just fine.