How to filter query based on a timestamp.

Database & APIs

Hi all, I'm a beginner with Flutterflow and I'm looking for some help. I have a calendar and instead of "0" I want to show how much scans were done on a certain day:


In my Firebase I have the following documentstructure with the scanLogs:

What have you tried so far?

I think it should be something like this, but because I compare unix timestamps (including seconds) with each other it's never exactly equal to each other resulting in a 0.

If I change the Equal To into "Less than" it shows sort of logical values, because the Time is less than that CalendarDate.

This is ofcourse not what I want to achieve, because I just want to show the scans on that day.
Can I somehow convert Time and CalendarDate both to ddMMYYYY before and then put that in the filter of the query?

Thanks so much for every help. ๐Ÿ™

Did you check FlutterFlow's Documentation for this topic?
No
1