How to check if a date is between 2 date fields

[Paul_Danyliuk]

FYI here’s the most optimal solution for finding date overlaps:

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…