Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here
Jan 07, 2021 05:49 AM
I want to make a search formula where i only want to show avaiable houses. The houses are being rent with an start date and also an end date. For example i have 3 houses.
house1 is rented from 1-1-2020 untill 6-1-2020
house2 is rented from 1-2-2020 until 17-2-2020
house 3 is not rented
I want to show available houses for someone who wants to rent from 1-2-2020 untill 6-2-2020.
So house 2 needs to be filtered out.
Can someone help? Thank you
Jan 07, 2021 12:30 PM
Hi @Maurice_Dibbets and welcome to the community!
Could a filter like this help?
Although I would recommend using 2021 :smiling_face_with_halo: