+ Start a Discussion
RSomaniRSomani 

Get Current Dated Exchange Rates in a Formula Field

Hi,

How to get Current Dated Exchange Rates in a Formula Field in a multi-currency enabled system.

I have applied below formula but it is returning Corporate Currency Rate not the Current active rate.

CURRENCYRATE(Text(CurrencyIsoCode))

Please suggest.
Thanks
Romesh
NagendraNagendra (Salesforce Developers) 
Hi Somani,

A formula function 'CURRENCYRATE(IsoCode)' is now available. Haven't found any documentation on this but is simple to use. Just make reference to the IsoCode in the formula and it returns the exchange rate.

I put together an article that gives a little more detail on this function -  Don't hesitate to drop me a note if you have any questions.

For more informaiton please check with below link which might help. Please let us know if this helps.

Thanks,
Nagendra
Amy MayerAmy Mayer
Did you ever find a way to get the Dated Exchange Rates in a formula instead of the Corporate Currency Rate?