2 Replies Latest reply: Dec 27, 2017 7:23 AM by Mark Bustin RSS

    Stuck - Can't form proper set expression for date range via input box

    Mark Bustin

      I cannot figure out the proper syntax to get the proper set of records between a date range using two variables and input boxes.


      I created vStartDate and vEndDate variables and capture them via two input boxes and then use date#  to convert to dates but -cannot not get it to work... any helpwould be greatly appreciated. -Mark


      count({$<ReceivedDate = {">= date#('$(vStartDate)','MM/DD/YYYY') <= date#('$(vEndtDate)','MM/DD/YYYY') "}>} TrackingNumber)