1 Reply Latest reply: Feb 13, 2011 2:39 PM by Vlad Gutkovsky RSS

    date filter

      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,
      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.



        • date filter
          Vlad Gutkovsky

          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