Hi Bea,
Try this:
select BaseCurrency, QuoteCurrency, ExchangeRate, EffectiveFrom from CurrencyExchangeRate
(Obviously this gives you all exchange rates, so you'll have to filter it for your currency and date but these are the basic query and fields to use)
Hope this helps,
Ophir
Comment actions