Date comparison

Simon_BI — Tue, 19 Nov 2019 03:15:55 GMT

Here i want to only load data with End_Date >= '7/1/2020'.

It works when i just script like Where END_DATE >= '7/1/2020' , but it fails when i use variable to replace '7/1/2020'.

Attached is my script, could someone help me to find out why the variable doesn't work?

Thanks

let vr = addmonths(monthstart(date(Today(),'M/D/YYYY')),8);

T1:
LOAD * INLINE [
ITEM, COUNTRY, END_DATE
30234229, AU, 12/1/2020
30234229, SG, 2/1/2014
30234229, HK, 2/1/2014
30234229, TH, 2/1/2014
30234229, CN, 2/1/2022
30234229, TW, 2/1/2014
30234229, JP, 1/1/2100
30234229, ID, 2/1/2014
30234229, MY, 2/1/2014
30234229, KR, 12/1/2024
30234229, IN, 4/1/2018
];

NoConcatenate
T2:
LOAD *
Resident T1
//Where END_DATE >= '7/1/2020' ;
Where END_DATE >= $(vr);

DROP Table T1;

Re: Date comparison

Lisa_P — Tue, 19 Nov 2019 03:25:13 GMT

missing the 'quotes'

... Where END_DATE >= '$(vr)';

Re: Date comparison

Simon_BI — Tue, 19 Nov 2019 05:03:31 GMT

yes yes yes, you're right. Thank u so much

topic Re: Date comparison in QlikView

Date comparison

Re: Date comparison

Re: Date comparison