6 Replies Latest reply on Aug 14, 2014 11:13 AM by Zac Hilbert

    Set date parameter from a database row

    Matt Bechard

      Hello,

       

      I am stuck on trying to figure this out.  Essentially, I am looking to pick an Incident # from a filter and set two dates, as a start date and a resolved date.  I will be using these start and resolved parameters as part of my dynamic sql query.  I have the dynamic sql passing the paramerers.  The problem is the parameters do not reflect the current database row that is selected.

       

      In the below picture, selecting the drop down filter is meant to set the two date parameters below it.

       

      inc.gif

       

      I have attached the sample workbook,

       

      Thanks

      Matt