2 Replies Latest reply: Sep 12, 2017 1:52 AM by zahid Rahim RSS

    Date Passing to other table

    zahid Rahim

      Dear Experts,

       

      I have made a qvd file with fields like:

       

      Actual Sale

      ---------------------------------

      TRX_DATE

      SALE_VALUE

       

      Now i want to make another qvd file with conditions on what is user selecting from above TRX_DATE

       

      DUE_INVOICES

      ----------------------------------

      DUE_AMOUNT

      WHERE DUE_DATE < TRX_DATE (First Value from the selected dates)

      AND DUE_DATE2 > TRX_DATE (Last Value from the selected dates)

       

      What can/should be the approach?

       

      Best Regards,

       

      Zahid Rahim