Validate Non-Overlapping Date Range when edit the row

hi all
i came from steve Validate Non-Overlapping Date Range
i use the formula to insure of any new row doesn’t exist in same ranges of any rows
and its very worked good
my problem its when i try to edit any record tell me “this entry is invalid”
i think that’s because the current date range is still active in this row

so i need to get help with any strategy can solve this (update record with same dates)

AND(
 ([to] > [from]),
 (COUNT(
   FILTER(
     "sessions",
     OR(
       AND(
         ([from] >= [_THISROW].[from]),
         ([from] <= [_THISROW].[to])
       ),
       AND(
         ([to] >= [_THISROW].[from]),
         ([to] <= [_THISROW].[to])
       )
       AND(
         ([from] < [_THISROW].[from]),
         ([to] > [_THISROW].[to])
       )
     )
   )
 ) = 0)
)
0 3 203
3 REPLIES 3
Top Labels in this Space