<= >= for date stored in variable

[baarathi]

First Name	Last Name	Date of Joining	Designation	Location	Salary
Gaja	Ramalingam	1/1/2007	Project Manager	Chennai	10000
Jagan	Mohan	1/1/2008	Senior Developer	Chennai	7000
Vishal	Shete	1/1/2012	Project Manager	New York	10000
Laxman	Reddy	2/2/2012	Senior Developer	New York	20000
Karun	Nair	3/3/2012	Senior Developer	Chennai	30000

Let varLastReloadDate = '1/1/2018';

Let varSal = 7000;

Let varThisReloadDate = '2/2/2018';

LOAD

    "First Name",

    "Last Name",

    "Date of Joining",

    Designation,

    Location,

    Salary

FROM [lib://Temp/Employee.xls]

(biff, embedded labels, table is Sheet1$)

Where "Date of Joining" > $(varLastReloadDate);

Let varLastReloadDate = varThisReloadDate;

As per the logic the above line should not load any line. But the entire 5 rows are loaded in script. In qliksense, does > and < work opposite for date?

[Digvijay_Singh]

Looks like $(varLastReloadDate) is numerically calculated, try putting apostrophe around.

[sunny_talwar]

Use single quotes around your variable and see if that works

Let varLastReloadDate = '1/1/2018';

Let varSal = 7000;

Let varThisReloadDate = '2/2/2018';

LOAD

    "First Name",

    "Last Name",

    "Date of Joining",

    Designation,

    Location,

    Salary

FROM [lib://Temp/Employee.xls]

(biff, embedded labels, table is Sheet1$)

Where "Date of Joining" > '$(varLastReloadDate)';

[zebhashmi]

Let varLastReloadDate = 1/1/2018;

or

Let varLastReloadDate =Date(1/1/2018, D/M/YY);