Automatic Merging of Effectivity Ranges
When you enter multiple ranges of dates in the Set Effectivity Range window, the effectivity ranges are automatically merged if the difference between the end date of range 1 and the start date of range 2 is:
• Less than or equal to one minute, if effectivity date includes time stamp
or
• Less than or equal to one day, if effectivity date does not include time stamp.
The following table explains the conditions given above.
Effectivity range with time stamp:
|
Items
|
Start date – End date
(mm/dd/yyyy)
|
Start date – End date
(mm/dd/yyyy)
|
|---|---|---|
|
Range 1
|
6/5/2017 02:00 pm – 6/6/2017 02:00 pm
|
6/5/2017 02:00 pm – 6/6/2017 02:00 pm
|
|
Range 2
|
6/6/2017 02:01 pm – 6/7/2017 02:00 pm
|
6/6/2017 02:02 pm – 6/7/2017 02:00 pm
|
|
Difference between end date/time of range 1 and start date/time of range 2
|
1 minute
|
2 minutes
|
|
Effectivity range
|
6/5/2017 02:00 pm – 6/7/2017 02:00 pm
The effectivity ranges are merged.
|
6/5/2017 02:00 pm – 6/6/2017 02:00 pm, 6/6/2017 02:02 pm – 6/7/2017 02:00 pm
The effectivity ranges are not merged.
|
Effectivity range without time stamp:
|
Items
|
Start date – End date
(mm/dd/yyyy)
|
Start date – End date
(mm/dd/yyyy)
|
|---|---|---|
|
Range 1
|
6/6/2017 – 6/7/2017
|
6/6/2017 – 6/7/2017
|
|
Range 2
|
6/8/2017 – 6/9/2017
|
6/9/2017 – 6/10/2017
|
|
Difference between end date of range 1 and start date of range 2
|
1 day
|
2 days
|
|
Effectivity range
|
6/6/2017 - 6/9/2017
The effectivity ranges are merged.
|
6/6/2017 - 6/7/2017, 6/9/2017 - 6/10/2017
The effectivity ranges are not merged.
|
 |
If you enter more than 2 effectivity ranges, the merging conditions are evaluated between all the ranges in all possible combinations. For example, when you enter 3 ranges, if range 1 and range 3 meet the conditions, they are merged and range 2 is not merged.
|
|
|
The merging feature is enabled by default and cannot be disabled.
|