Date Range doesn't let you do + minutes

[NigelG]

Am I missing something, or does range not really let you set … a range in a simple way.

So you can’t do range = date date + 1 hour.

[mikeloc]

It doesn’t appear that you are missing anything…

Cannot Modify the Date Range Operation :end date in Condition?

Hi Bubblers, In a way I am continuing this topic: Unfortunately there seems to be no way to modify the end of a date range to add extra days, months…Its only available on the start of a date range. I am trying a create a few days window each way on a search, both on the start and end date via a filter on a RG. [image] Is there any workaround that doesn’t involved modifying the actual data? Cheers!

Check out this response in the linked thread for a creative workaround from a pretty smart chap.

How you you manipulate a Date Range's :end date?

You are right, it doesn’t seem to work that way. A bit of a hack … (but it works)… create the range, with the “end” date unmodified. Then makes changes to the thing, and switch the placing of the start and end, so you update the end date first… and leave the start at the end, untouched. [image] [image] [image] And raise a bug

[NigelG]

@mikeloc

Check out this response in the linked thread for a creative workaround from a pretty smart chap.

Hey, who is that guy

So it hasn’t been fixed since 2017

[jared.gibb]

I do these range change calculations prior to saving by using hidden inputs. Not ideal but 1 working workaround for now.

Probably not always possible in all cases.

[sudsy]

@NigelG

So you can’t do range = date date + 1 hour.

But what does it mean to increase a range by 1 hour? Does it mean shift the entire range into the future by 1 hour (which implies adding 1 hour to both bounding dates)? Or does it mean increase the length of time represented by the range (which implies adding 1 hour to the end date only)? Both seem to be valid interpretations.

For a booking application, it might make sense to maintain separate custom states for each bounding date (perhaps Time Slot Start and Time Slot End on the parent group in your example). That way, either or both of the bounding dates could easily be updated via the UI. Then, any DB operations (create / modify) would reference those custom states to create the range.

Also, for semantics and readability, I wonder if Booked Slot might be better than Booked Date, as the former implies a range.

(Just some suggestions based on my own struggles with dates. But enough about my personal life… )

[NigelG]

@jared.gibb

I do these range change calculations prior to saving by using hidden inputs.

Yeah, I just used a small group to hold it. It is just a date + hours from a Option Set.

[NigelG]

@sudsy

But what does it mean to increase a range by 1 hour? Does it mean shift the entire range into the future by 1 hour (which implies adding 1 hour to both bounding dates)? Or does it mean increase the length of time represented by the range (which implies adding 1 hour to the end date only)? Both seem to be valid interpretations.

You can manipulate the start of the range as a date, but not the end. In this case I just have a start date/time and it is 1 hour long.

[sudsy]

@NigelG

You can manipulate the start of the range as a date, but not the end.

Understood.

I’m suggesting that’s due to Bubble’s left-to-right approach to evaluating expressions. As soon as an end date is specified, the expression at that point “evaluates to” a date range type - not a date type - and so Bubble presents operations relevant to that type.

I’m not saying it couldn’t or shouldn’t be implemented differently, but it does seem consistent with the way the dynamic expression builder works in general; and so strictly speaking, it’s probably not a bug.