Share
Report
13Neither of the new dates touches in between any of the existing dates in the table
events shouldn't collide with existing dates neither from the start or end even in between.
if the new start date is in between the old [start date and time] and [End date and time] of the event
OR
if the new end date is in between the old [start date and time] and [End date and time] of the event
| Start Date And Time | End Date And Time | |||
| new event | 2022-07-01 12:00 | 2022-07-15 12:00 | ||
| ID | Member | Start Date And Time | End Date And Time | pick |
| 1 | event 1 | 2022-05-24 10:00 | 2022-05-27 9:00 | |
| 2 | event 2 | 2022-05-25 10:10 | 2022-06-30 10:10 | |
| 3 | event 3 | 2022-05-25 12:54 | 2022-07-19 12:54 | yes |
| 4 | event 4 | 2022-05-27 2:00 | 2022-05-27 2:00 | |
| 5 | event 5 | 2022-06-15 9:15 | 2022-06-15 9:51 | |
| 6 | event 6 | 2022-06-27 0:00 | 2022-07-04 0:00 | yes |
| 7 | event 7 | 2022-06-29 0:00 | 2022-06-29 0:00 | |
| 8 | event 8 | 2022-06-29 0:00 | 2022-06-29 0:00 | |
| 9 | event 9 | 2022-06-29 0:00 | 2022-06-30 0:00 | |
| 10 | event 10 | 2022-06-29 0:00 | 2022-07-04 0:00 | yes |
Categories:
All responses (
Answers (
