How to check for overlapping events

[Ryan_Martens]

It is indeed a quite complex formula. I just posted the suggestion of having a date overlap formula for this kind of thing.

Need an easy way to test for overlapping date ranges (and DateRange data type)

The Problem The need to test if two events are conflicting or not has come up several times, and every time I have to rack my brain to remember or re-invent the formula that looks something like this: ([event 1].[start time] > [event 2].[start time] AND [event 1].[start time] < [event 2].[end time]) OR ([event 2].[start time] > [event 1].[start time] AND [event 2].[start time] < [event 1].[end time]) The first problem is, with as much logical brain power as it took to write that, I’m still no…