What is the best way to manage a query for Firebase Docs falling between start date & end date

Database & APIs

I want to query all documents in a collection that fall between startdate and enddate

i.e.

startDate<= CurrentDate AND endDate >= CurrentDate

What have you tried so far?

Using the query builder throws this error but it is possible in Firebase using the built in query builder.

I'd have thought this an extremely common query to extract docs between 2 dates.

I'd rather not use conditional visibility on the Listview, because if the app scales it could start to return 1000s of records if I use just one "not-in" operator.

What are other people doing?

Cheers

Did you check FlutterFlow's Documentation for this topic?

Yes

1 reply