If a supplier advises that another rate period is available inside an existing rate period, or an error in setting the dates has been made, then inserting a new date range inside an existing date range requires the existing date range to be split.

For example, if the existing date range is 01 Apr 2024 – 31 Mar 2025 and the new rates apply for the period 24 Dec 2024 – 02 Jan 2025, then in effect, there will be three date ranges:

• 01 Apr 2024 – 23 Dec 2024.
• 24 Dec 2024 – 02 Jan 2025.
• 03 Jan 2025 – 31 Mar 2025.

In splitting a date range, the Start Date of each rate period is entered into the Date Range Start field. This means that, for this example, 2 new start dates need to be entered; 24 Dec 2024 and 03 Jan 2025.

Because the start date of the date split is the only date that needs to be entered, multiple splits can be performed in the same operation if necessary.

Split a Date Range

1. Make sure at least one rate has already been added (see Add a Rate).
2. Click the Rate Period that you want to split (single click only - this opens the date range).

   

3. Click Split Date Range.

   

4. Add the start date of the first new rate period on the Split Rate screen (e.g. 24/12/2024).

   

5. Click the + symbol beside the Date Range Start calendar icon.

   

   This action has created a new end date of 23 Dec 2024 for the existing date range. It now has validity periods of:

   • 01 Apr 2024 – 23 Dec 2024
   • 24 Dec 2024 – 31 Mar 2025

   The Date Range Start field will now be blank and the current date range(s) will display.
6. Enter the start date of the second rate period on the Split Rate screen (e.g. 03/01/2025).

   

7. Click the + symbol beside the Date Range Start calendar icon.

   

   This has created a new end date of 02 Jan 2024 for the existing date range. It now has validity periods of:

   • 01 Apr 2024 – 23 Dec 2024
   • 24 Dec 2024 – 02 Jan 2025
   • 03 Jan 2025 – 31 Mar 2025

   The Date Range Start field will now be blank and the current date range(s) will display.

8. If the Date Range is to be Split for all Price Codes, select Split All Applicable Price Codes.

9. If you want to keep the changes, click OK.

   

10. Click Exit to discard any changes.

    

When ‘OK’ is clicked, the new date ranges will be inserted, with all Price Codes and rate types from the date range which has been split.

Splitting the rate performs the following functions automatically:

• Truncates the original date range (prior to the split) to be the day before the split starts (changed from 31 Mar 24 to 31 Mar 25).
• Inserts the new date range.
  •  (24 Dec 19 - 02 Jan 25)
  • (03 Jan 25 - 31 Mar 25)
• Inserts a new date range with the start date being the day after the new split end date, and the end date being the original end date of the range that was spilt.

The rates for the new date range can be edited via the Rates tab.