Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,