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…

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

Paul_Danyliuk September 24, 2021, 11:39am 9

Bumping this old thread with a long-read that I just posted:

TL;DR: Don’t use the solution in this thread unless you specifically need the count of overlapping days.

Topic		Replies	Views
Date overlap formula	5	793	February 21, 2022
Optimizing Date Overlap Comparison	8	1330	September 24, 2021
Checking for date overlaps — the most optimal formula Tips and Hacks	3	6174	February 7, 2024
Overlapping Date Ranges	4	735	October 9, 2023
How to check for overlapping events	9	2690	February 23, 2022