Meeting room reservation platform

[Christiaan_Huizer]

hi @Tazi_Ghita , welcome and this interesting question already provoked @Paul_Danyliuk to provide a way to solve this puzzle

Checking for date overlaps — the most optimal formula

TL;DR: Room.Bookings.Filter( CurrentValue.End > Search.Start AND CurrentValue.Start < Search.End ).IsBlank() A popular requirement is to test whether a certain date range overlaps with any of the ranges in a dataset. For example: search which of the rooms are available for requested check-in/check-out dates given the database of all bookings. There’s been a few (1, 2, 3) topics about this already. Actually I even replied to one of these: My reply got lost because recently I learned th…

enjoy the learnings!