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
Optimizing Date Overlap Comparison	8	1166	September 24, 2021
Need an easy way to test for overlapping date ranges (and DateRange data type) Suggestion Box	8	8487	September 24, 2021
Checking for date overlaps — the most optimal formula Tips and Hacks	3	5128	February 7, 2024
Date overlap formula	5	663	February 21, 2022
Overlapping Date Ranges	4	560	October 9, 2023

How to check for overlapping events

Related Topics