Sum numbers between dates


It’s my 3. day using bubble and I got stuck on this.
To put it simply, I got some numbers and each number has its date, the user inputs 2 dates in 2 date fields (start and end time) and gets the sum of all numbers between those 2 dates.

I’ve figured out how to get just the sum of all numbers: search for ‘type’:each item’s '‘number’:sum

Basically this:
select sum(Value) from my-table where Date between ‘2022-xx-xx’ and ‘2022-yy-yy’;
…just in bubble

Any ideas?

Hi @matko.micic :wave:
If i understood well, If you have 2 input dates then you can try like this…


Damn, works like a charm.

Thank you!

1 Like