date filter

Sun, 13 Feb 2011 16:21:35 GMT

I have a variable taking date from user - vDate. I am using Input box to accept this value.Based on this date I need to filter data. My data should be based on following conditions.

prd_Id:
load distinct [PRDCT_ID] as ID,
resident Product
where $(vdate) between beg_dt and end_dt;

(this beg_dt and end_dt are the database fields)

Can anyone tell what would be the correct syntax.

Thanks,pooja

date filter

vgutkovsky — Sun, 13 Feb 2011 19:39:55 GMT

where beg_dt <= $(vdate) and end_dt >= $(vdate)

You might also not need the $() expansion, depending on how you read the variable in. So if the above doesn't work, try this: where beg_dt <= vdate and end_dt >= vdate

Regards,

topic date filter in QlikView

date filter

date filter