I’m creating a scheduling app for our sports performance company. There are a variety of events going on all day from group classes to offsite classes and personal trainings. Right now trainers can put in their own PTs (personal trainings) and requests off from work and our scheduling manager can pu…

Just in case someone still finds this old thread — THIS is the ultimate answer: [image] Checking for date overlaps — the most optimal formula Tips and Hacks TL;DR: Room.Bookings.Filter( CurrentValue.End > Search.Start AND CurrentValue.Start < Search.End ).IsBlank() …

How to check for overlapping events

Paul_Danyliuk February 23, 2022, 10:45pm 9

Just in case someone still finds this old thread — THIS is the ultimate answer:

Topic		Replies	Views
Overlapping Date Ranges	4	854	October 9, 2023
Need an easy way to test for overlapping date ranges (and DateRange data type) Product Feedback	8	10367	September 24, 2021
Checking for date overlaps — the most optimal formula Tips and Hacks	3	6850	February 7, 2024
Optimizing Date Overlap Comparison	8	1443	September 24, 2021
Date overlap formula	5	892	February 21, 2022

How to check for overlapping events

Related topics