[SOLVED] How to query documents using a date field, having in consideration timezones?

Lets say I save a document at 05:00 am GTM-6 on feb 01, it will be saved in the database in UTC as 23:00 of January 21, If I query my documents of Feb 01, that specific document wont appear, is there a way to handle this?

TL;DR

Solution: To query documents using a date field while considering timezones, you can use the `listDocuments()` function and include both greater and less queries that are AND-ed together. You'll need to calculate the beginning and end of the timezone's day. Make sure to create the proper index for it. For example, if you save a document at 05:00 am GMT-6 on Feb 01, it will be saved in UTC as 23:00 of January 31. If you query for documents on Feb 01, that specific document won't appear. To handle this, you can do a between query using `

I'd guess the best way is to do a between query. Query.greater() AND Query.less()

You'll need to make the proper index for it, but that should do the trick. You just need to calculate the beginning and end of the timezone's day.

When you query using listDocuments() the query parameter is a list of queries that are AND-ed together, so you just need both those greater and less queries in there.