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() …

Hey Ryan! You should be able to use the < and > operators to find overlapping events. Something like: thisTable.Filter(Trainer=thisRow.Trainer AND ((thisRow.[Start Time] > [Start Time] AND thisRow.[Start Time] < [End Time]) OR (thisRow.[End Time] > [Start Time] AND thisRow.[End Time] < [End Time]))…

Oleg, Thank you so much for this! That was epic and worked completely. I did add a third condition where they had equal start and end time. I’m just going to put the evolution of this for those that it may help in the future as well as for myself if I ever need to come back to this in future. What …

Awesome, glad you got it working! That’s quite a complex formula you have there. :grimacing: BTW, you might be able to simplify it by using >= (greater than or equal to) and <= (less than or equal to).

Thanks. The only problem with those signs is that it would grab those situations when one session ends at say 5pm and the next starts at 5pm. That’s okay for a coach to train back to back sessions but with the greater/less than or equal to signs it would register in those

It is indeed a quite complex formula. I just posted the suggestion of having a date overlap formula for this kind of thing. [image] Need an easy way to test for overlapping date ranges (and DateRange data type) Suggestion Box The Problem The need to test if two events a…

Dear @Ryan_Martens , Not sure if this is what you are looking for: [image] Min() - Max() - how to get what's between? If you want actual date values, this will work too: .FormulaMap(CurrentValue.DateTimeTruncate("month")) .Unique() Here’s an example: Credit…

@Ryan_Bonhardt Hey man, I’m working on a similar project. If you still have your doc, would you share it with the rest of us?

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	3	874	July 11, 2023
Need an easy way to test for overlapping date ranges (and DateRange data type) Product Feedback	8	10422	September 24, 2021
Checking for date overlaps — the most optimal formula Tips and Hacks	3	6884	February 7, 2024
Optimizing Date Overlap Comparison	8	1458	September 24, 2021
Date overlap formula	4	921	November 23, 2021

How to check for overlapping events

Related topics