date filter

[#1]

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

[vgutkovsky]

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,