This content has been marked as final. Show 3 replies
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.