How to Reset Data Per day

Hi, im sorry if i got double post today, because of forbidden content that i was asked.
but may i ask once again, and this is different things.

i am new in here, probably like 2 - 3 Weeks learning make apk with blocks

i have created an app that work for reporting data like sales or performance per day.
it works with Gdrive, everything data submitted, go through GDrive. and its working beautifully fine.

The problem i want to ask, how to reset sales that reported today, because i used TinyDB to only show data that reported today in app.

and it always show total reports even its already been weeks, i know becaused i call TinyDB.

what i want is, the data showed got resetted automatically per day.
if i report today 2, tomorrow should be resetted to 0 again.

How to make automatically reset per day it self ?

i think it could be work with clock elements logic, but really, i got no idea to start with.

Have any idea where i have to start with ?
Would you please help me?

Thank you ! :laughing::pray:

Its easy what you have to do is use date API bro simple

to be honest i dont know where to start with date API.

but thanks anyway, i already got the formula logic,
please tell me if i got wrong.


Use date comparison extension