How to do query of db by date?

[designlook]

I created a wildcard field called createdAt and it's Date.now() when I create a record (example: 2021-05-25T06:43:27.241Z)

When I do a query, how would I filter it by something like createdAt < Date.now() ?

[Duramax2018]

What all needs to be done. Would u be able to call me Sir

…

On Mon, May 24, 2021, 8:34 PM Scott Yu ***@***.***> wrote: I created a wildcard field called createdAt and it's Date.now() when I create a record (example: 2021-05-25T06:43:27.241Z) When I do a query, how would I filter it by something like createdAt < Date.now() ? — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#1186>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/ATI5UAHCRIAUDSNJOOIVY3DTPMLEFANCNFSM45OMPD2Q> .

[designlook]

I created a wildcard field called createdAt and it's Date.now() when I create a record (example: 2021-05-25T06:43:27.241Z)

When I do a query, how would I filter it by something like createdAt < Date.now() ?

I was able to get it working I think. Instead of saving date like new Date, I use Date.now()

var cutoff = Date.now() - 2 * 24 * 60 * 60 * 1000 // 2 days ago
appwrite.database.listDocuments('60axxxxxxxx8', [createdAt>${cutoff}])

[eldadfux]

@designlook you got it right, store dates as unix time stamps and use common operators to query it.