Get total amount base on filtered Date

[jigsgfx.gj]

Good Day,

what i want is to get the total amount of entries in a column in my database base on filtered date (Air Date/Time Picker)

ex.
**1.**if i set in the Air Date/Time Picker to July 6 it will show the total sum of entries that dated July 6 in a Text element
**2.**if i set in the Air Date/Time Picker to month of July it will show the total sum of entries that dated July in a Text element

or

i will create a 2 Air Date/Time Picker to be a Date Range

if i set
Air Date/Time Picker A = July 1
Air Date/Time Picker B = July 31

Results
it will get the Total Amount under at2-Funds column (image above) that has a Date from July 1 to July 31

and the results will be in the Text Element

the problem is i didn’t know how will i do this things…

Please help me

Thank You

[jigsgfx.gj]

anyone?

[louisadekoya]

You could try a search with an advanced filter - something like this:

So in your case, you would replace creation date with at-Date, score with at2-Funds and of course Users with whatever your data type is.

I haven’t done much with dates/ranges etc, so there is very likely a more optimal way to do this, perhaps using the operator?