USD to EUR conversion

[Tarasingh26]

Hi All,

I have requirement to convert USD to EUR based on date of first occurrence of event. I am using GlideCurrencyConverter('USD', 'EUR'). This is using fx_rate table to convert value. But this table contains data for last 6 years. My requirement is data should be in table which cover past 30 years. How this can be achieved? Should I create a new table for currency conversion or Should I import past 30 year's data into fx_rate table? Please let me know if anyone has faced same kind of issue.

Thanks,

Tara Singh

[Yashsvi]

Hi @Tarasingh26,

please check below link:

https://www.servicenow.com/community/developer-forum/conversion-of-usd-to-euro/m-p/2442484

Thank you, please make helpful if you accept the solution.

[Tarasingh26]

@Yashsvi Thanks for reply. That link is for code of conversion. In my case data in default rate table is available for 6 years but I need 30 years past data. I am not sure what is the best practice to bring data into fx_rate table.