Load table where date is between

[Anonymous]

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

[MayilVahanan · Accepted solution]

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.

[Anonymous]

Thanks a lot Mayil it worked just fine.