Reports in bubble

Possible you are trying to retrieve a list of items between two dates? If that is the case you probably mean to constrain the search with “after” dates and “before” dates.

https://manual.bubble.io/core-resources/data/operations-and-comparisons#date-type

Or something like this http://forum.bubble.io/t/using-created-date-in-constraints/225063
or like this http://forum.bubble.io/t/solved-doing-a-search-for-events-with-a-certain-date-time-invalidates-the-search/165022

The thing that catches many people, is that Dates in Bubble are to the second accuracy. So you need to “floor” the date to the beginning of the day by adding “-1” days. - or otherwise setting the HH mm ss to 0’s.

Then look for “how to sum a repeating group” in the Forum. It’s an age-old problem. :slight_smile:

1 Like