Unanswered: Does anyone have a good query for detecting schedule conflicts?
Hello, first post here.
I have a database of schedule data, and I need a query to detect conflicts. If event A starts at 10/1/09 3:00 and ends at 10/1/09 13:00; and event B starts at 10/1/09 12:00 and ends at 10/1/09 15:00 then the two are in conflict. I have searched all over to find a query to detect this kind of thing and come up empty. Anyone got any ideas?
That should give you 4 tasks, three of which are in conflict, ie. Task 2 starts and finishes during the time Task 1 happens, and Task 3 starts before task 1 ends, but finishes after Task 1. I need a query that will give me the three tasks that are in conflict. Does that make sense?