Dear everyone
I have a form with three columns: name, start date, and end date. I want to make sure that the date ranges for start and end dates entered into the form do not overlap or conflict with existing data.
Here’s an example table to illustrate the issue:
| Name | Start Date | End Date | Rule |
|---|---|---|---|
| Alfa | 01/01/2024 | 31/01/2024 | Ok |
| Alfa | 01/02/2024 | 28/02/2024 | Ok |
| Alfa | 14/02/2024 | 14/03/2024 | Not Ok |
Can anyone help me resolve this case?
Thank You