Eliminate duplicate

Hello guys,
I am trying to create some statistics based on database elements.
In this case I am dealing with dates and what I want to do is an occupation rate. So far I have accomplished that but I encountered one problem: duplicate dates. Because bookings have a start and end date there can be 2 booking in which the end date of one is the start date of other. I am using number of days in date range to calculate occupation rate. So this being said how can I eliminate one of the dates when there are two dates which are the same?

I just managed to fix this. Once again thanks to timex plugin doing wonders

It’s a built-in function of bubble

1 Like