BUILTIN.CURRENCY_CONVERT
This function converts a currency amount stored in a field to a target currency. The target currency is determined based on effective date of defined exchange rate. Currency Exchange Rates.
Parameters
|
Parameter |
Required / Optional |
Description |
Acceptable Parameter Values |
|---|---|---|---|
|
Original amount field |
Required |
The original amount field to convert. |
– |
|
Target currency |
Optional |
The currency to convert to. The default value is the default currency of the subsidiary. |
|
|
Date of the exchange rate |
Optional |
The effective date of exchange rate. The default value is today's date. |
– |
Syntax
BUILTIN.CURRENCY_CONVERT(sales.amount)
BUILTIN.CURRENCY_CONVERT(sales.amount, 1)
BUILTIN.CURRENCY_CONVERT(sales.amount, 1, TO_DATE('2019-01-30', 'YYYY-MM-DD'))