3 Replies Latest reply: Nov 14, 2014 7:56 AM by Roberto Galessi RSS

    Currency within 2 dates

    Roberto Galessi

      Dear All,

       

      I have two datasources. One of them has invoice number, invoice date, amount and currency fields. The other one has currency, exchange rate, start date, expiration date. I have make a connection with concatanation of currency and date between two table.

      Of course the invoice date must fall within 2 dates and give me back the right exchange rate.

       

      Looking forward to having a solution.

       

      Thank you

      Roberto