Load Where Field = Field

[william_denholm]

I have data set as below

Ref No	Date Entered	Date Req
1	01/01/2016	01/01/2016
2	10/10/2016	11/10/2016
3	21/02/2016	16/05/2016

I have this data in a temp table and want to do a resident load where the date entered is the same as the date req or is the day before the date req.

I've tried the below but it's not showing anything. Suggestions welcome

LOAD [Ref No],

     [Date Entered],

     [Date Req]

Resident Temp1

WHERE ((DATE([Date Entered]) = DATE([Date Req]) or ((DATE([Date Entered]+1) = DATE([Date Req])));

[sunny_talwar]

May be like this:

TableNew:

NoConcatenate

LOAD [Ref No],

     [Date Entered],

     [Date Req]

Resident Temp1

WHERE [Date Entered]) = [Date Req] or [Date Entered]+1 = [Date Req];

Just make sure that dates are read correctly by QlikView and also dates are just dates and not timestamps

Get the Dates Right

Why don’t my dates work?