Discussion board where members can get started with QlikView.
I have data set as below
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],
WHERE ((DATE([Date Entered]) = DATE([Date Req]) or ((DATE([Date Entered]+1) = DATE([Date Req])));
May be like this:
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?