# How can I filter rooms available between 2 dates selected

**URL:** <https://forum.adalo.com/t/how-can-i-filter-rooms-available-between-2-dates-selected/65620>\
**Category:** Get Help\
**Created:** [February 11, 2026, 6:43pm UTC](https://forum.adalo.com/t/how-can-i-filter-rooms-available-between-2-dates-selected/65620 "2026-02-11T18:43:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pedupont](https://avatars.discourse-cdn.com/v4/letter/p/71c47a/32.png) [@Pedupont](https://forum.adalo.com/u/Pedupont)\
**Post date:** [February 11, 2026, 6:43pm UTC](https://forum.adalo.com/t/how-can-i-filter-rooms-available-between-2-dates-selected/65620/1 "2026-02-11T18:43:11Z")

</div>

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.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/b/0/b0493a339b02e50a5809567fa06fb9ccee057bd2.jpeg)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/adalo/original/3X/f/f/ff6a5683ce20be278167c8a25fcbfcbc2b577d03.png)

---

<div class="post-metadata">

**Author:** ![JasonM](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/jasonm/32/39793_2.png) [@JasonM](https://forum.adalo.com/u/JasonM)\
**Post date:** [February 12, 2026, 3:13pm UTC](https://forum.adalo.com/t/how-can-i-filter-rooms-available-between-2-dates-selected/65620/2 "2026-02-12T15:13:55Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.adalo.com/system/32/40401_2.png) [@system](https://forum.adalo.com/u/system)\
**Post date:** [February 22, 2026, 3:13pm UTC](https://forum.adalo.com/t/how-can-i-filter-rooms-available-between-2-dates-selected/65620/3 "2026-02-22T15:13:59Z")

</div>

Closed on February 22, 2026, 3:13pm UTC

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.