Formula query for total

Question

**EDITTED- I figured it out! But now I can't figure out how to delete this post...there is not enough caffeine in the world today...Hi All- my brain is fried and I can't figure out this but hoping one of ya'll knows this easy peasy (Looking at your genius Mark Shnier!). Basically I have a table that I want to create a formula query to get totals from another table after a certain date.&nbsp;
So there is a total field on one table [Total Ride Cost] and a date field [Date of Ride]. I want it to pull and total all of the total ride costs after April 1 and put that into a second table.&nbsp;Thoughts?
------------------------------Annalise Sansouci------------------------------

markshnier__you · Answer

Can you post your successful formula?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

annalisesansouc · Answer

SumValues(GetRecords("{9.GT.'"&amp;Date(2022, 3, 31)&amp;"'}",[_DBID_RIDES]),11)How did I do Mark!?------------------------------Annalise Sansouci------------------------------

Forum Discussion

Formula query for total