How can I filter rooms available between 2 dates selected

[Pedupont]

Hello everyone.

I am preparing a new application for a new hotel and I am conducting tests for booking packages and rooms.
I want to show the rooms that are available for booking between two specified dates. I have a collection of reservations that is associated with a collection of rooms and I’ve been looking for a while how to make only the rooms that are not booked in this dates range appear.

I can only select the reservations and count, I don’t see how I can filter on the reservation dates.

Thanks.

[JasonM]

Hello Pedupont,

I see you have a true/false Boolean property titled Is_Active. I assume that is true if the room is available to book. If so, have you tried selecting that property and setting the filter to Is_Active is True? I hope this helps.