Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
adoteykwame
Contributor

Load table where date is between

Hi,

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

LOAD

A

B

C

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

1 Solution

Accepted Solutions

Re: Load table where date is between

HI

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.

2 Replies

Re: Load table where date is between

HI

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.

adoteykwame
Contributor

Re: Load table where date is between

Thanks a lot Mayil it worked just fine.

Community Browser