I've got a sales tables with transactions spanning every weekday. The sales transaction is logged in local currency (EUR) but I want to convert the report to USD. My currencyrate table is however only updated on saturdays. So I would like get the latest available currencyrate to calculate my report with. Any good ideas?
For the example below I would like to get 1,18 and 1,2 for the two different transactions and sum up the total