is it possible to allow users to select a date range? [image]

What i’m trying to do, is to store a date range in a list of dates. For example all the dates between checkin and check out. Apparently it’s more complex then i thought. But what if i could calculate the number of days between checking and checkout, convert checkin and checkout dates to text, and c…

yes, we have implemented it. in the search results we simply show a repeating group where listings available dates fall within the selected filters. That means the available dates are greater than the “from” date and at the same time are less than “to” date. Thanks, Levon. [image] Founder at Bub…

so one listing can have multiple booking dates right? how do you store this dates? as date or you format it as number? thank you

Yes, one listing can have multiple dates. It’s better to store them as dates not numbers

Hey Levon, I’m having a similar issue. So let’s say your database says the following (which represents existing reservations in the database for an existing property): Reservation start date 9/3/2016 (Reservation 1) 9/12/2016 (Reservation 2) Reservation end date 9/7/2016 (Reservation 1) 9/16/2…

But if you store as dates, you aren’t given the option to filter as greater than or less than, correct? this is where I’m getting stuck. I only see the ability to filter by “contains/does not contain” and “is/is not empty.” How did you get around this? @emmanuel – this feels like this should be a…

You want to work on lists I would have thought… If you have a list of the dates that are to be booked, and a list of booked dates, and the count from … [image] Bubble Reference Full reference for each Bubble element, feature, plugin. Bubble is a visual programing language. Instead of typ…

Yes, I should have clarified – I was talking about on a list. Your solution makes sense in theory! I hadn’t used the intersect function before. Let me give a try and report back. Thanks, Nigel!

Hey guys, In addition to Nigel I think I have a solution as well. So if you have a hotel, each individual room is going to have a unique identifier that differentiates it from other rooms. This is not a perfect solution, but what you can do is put a listing of all dates in the future up until a cer…

Also I know the above would imply you have to manually manage this database to make sure you dont run out of time in the future or it gets too big, but there’s probably some type of “do when condition is true” that allows the database to automatically to add a date in the future whenever you want.

Select date range like in Airbnb - is it possible?

Questions

emmanuel September 22, 2016, 4:10pm 22

See this

we added such data type.

Topic		Replies	Views
[New Feature] Date and Number Range support New features	40	26158	July 31, 2022
Stuck on Searching for Holiday Listing Available Dates as a Date Range Need help	13	2403	December 8, 2018
Sorting by date ranges Database	16	1670	April 13, 2023
Booking system help Questions	19	9252	July 8, 2020
Hotel rooms - available and booked Need help	17	3155	September 22, 2016

Select date range like in Airbnb - is it possible?

Related topics