Date field vs date variable comparison

lbunnell — Sat, 16 Nov 2024 03:32:35 GMT

I'm trying to make a comparison evaluation between a date variable and a date stored in a table. I've tried several methods based on community posts, but can't seem to get this to work. The date is stored in the table in the format MM/DD/YYYY.

SET vLast30 = today()-30;

NoConcatenate
Table1:
Load *,
if(OPN_DT>date('$(vLast30)','MM/DD/YYYY'),'Yes','No') as [Too New]
Resident Extract;

I tried setting the variable like date((today()-30)),'MM/DD/YYYY') and tried several variations of num# with date functions but the comparison isn't made after the file loads and the $(vLast30) variable shows 43571 after load.

Re: Date field vs date variable comparison

jonathandienst — Fri, 17 May 2019 13:15:02 GMT

Try without the quotes and date mangling:

if(OPN_DT > $(vLast30), 'Yes', 'No') as [Too New]

Re: Date field vs date variable comparison

lbunnell — Fri, 17 May 2019 13:22:45 GMT

It's always easier than I try to make it out to be -lol. Thanks!

topic Date field vs date variable comparison in QlikView

Date field vs date variable comparison

Re: Date field vs date variable comparison

Re: Date field vs date variable comparison