I have two formula fields: one on the Opportunity and one on the OpportunityLineItem that are calculating the exchange rates to USD:
CASE( CurrencyIsoCode , "EUR", Amount * 1.11, "GBP", Amount * 1.2, "HKD", Amount * 0.11, "USD", Amount, 0)
The formulas are working perfectly fine, but I need them to keep the exchange rates for each FY. I know I can create a new field for 2021 exchange rate, but I would like to keep the same formulas for the user experience and best practices.
I was looking to use CreatedDate ">=1/01/2020" and "<=31/12/2020", but I am unable to save the formula now.
Any help is much appreciated. Thanks.