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 coursetheinvoice datemust fallwithin 2datesandgive me backthe rightexchange rate.