Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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])));
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