Rates Tab

Use the Rates tab to enter the rates used to convert currencies, and the effective time frames for the rates.

currency editor, rates tab, explained below

Date Ranges

Enter the effective date range for the specified currency conversion rates. To modify the date ranges, right-click to select from the shortcut menu. Assign date ranges to accommodate periodic fluctuations of currency rates. Date ranges must not overlap.

currency editor, rates tab, used to assign a date range

Rates

From
Currency
The source currency for the conversion rate specification. Enter a currency code or click the down arrow to select from a list of currencies.
Description
The description of the currency code.
To
Currency
The destination currency for the conversion rate specification. Enter a currency code or click the down arrow to select from a list of currencies.
Description
The description of the currency code is displayed.
Rate
A multiplier used to convert from the source currency to the destination currency, in each date range.
Note: You can specify zero (0) to cause a deliberate runtime error. Use a zero rate to purposely prevent processing currency conversions for a particular From/To currency within a specific date range.

Insert Date Range

Right-click in the Date Ranges group box and select Insert Date Range from the shortcut menu to display the Insert Date Range dialog. Enter the Start Date and End Date for the new date range. The existing date ranges are automatically adjusted to include the new range.

currency editor, insert date range display, explained below
Start Date
Click the arrow to select a Start Date for the new date range.
End Date
Click the arrow to select an End Date for the new date range.
Copy rates from an existing …
Click the arrow to select a previously-defined date range.
Delete Date Range
Right-click the date range and select Delete Date Range from the shortcut menu. Select an option in the Delete Date Range dialog to combine the deleted range with the previous range or the next range.
currency editor, delete date range panel, explained above