Date range filter on a list of date ranges

I’m trying to filter a repeating group based on user selected date range, where a booking already has a list of bookings with a date range.

I’ve tried “is contained by” “overlapped with” all return the same error.

the issue is that “is contained by” accepts a single date range, while you’re passing a list of date ranges. Can you explain your use case a little more?

Its a bookings app for desks within a building. So a desk can only be used once at a time. When someone books a desk that booking is added to the desk table. So a desk as a list of bookings. Each booking has a date range. When creating a new booking i want to only show available desks within the range they have selected.

This topic was automatically closed after 70 days. New replies are no longer allowed.