topic Re: Date variable in QlikView

Date variable

simonwithey — Wed, 25 Nov 2020 16:16:04 GMT

I have the following variable:

LET vMonthStart = monthstart(Today());

Then in my data load I have:

WHERE "My_Date" < $(vMonthStart);

It returns no records but if I use WHERE "My_Date" <> $(vMonthStart); it does.

I need the less than function to work rather than not equal to.

What am I doing wrong??

Many thanks

sunny_talwar — Mon, 18 Dec 2017 16:46:33 GMT

May be add single quotes around your variable

WHERE "My_Date" < '$(vMonthStart)';

simonwithey — Tue, 19 Dec 2017 08:57:42 GMT

Cheers Sunny, that seems to work. Thanks for the prompt response.

its_anandrjs — Tue, 19 Dec 2017 09:09:34 GMT

May be you can use it direct also

Ex:-

WHERE "My_Date" < vMonthStart

WHERE "My_Date" < '$(vMonthStart)'

sunny_talwar — Tue, 19 Dec 2017 09:18:35 GMT

That's awesome, please close the thread if you got what you wanted.

Best,

Sunny