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.
load distinct [PRDCT_ID] as ID,
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.