Query documents with datetime

I am trying to get documents, that were created 24h ago or earlier. my code doesn't work (I just get {"total":0,"documents":[]}). What am I doing wrong is there a better way to do it?

TypeScript

    const offset = (24 * 60 * 60 * 1000);
    const date = new Date();
    date.setTime(date.getTime() - offset);

    let promise_get = databases.listDocuments(
        dbToUse,
        collectionToUse,
        [
            Query.lessThan('$createdAt', date)
        ]
    );

TL;DR

The developer is trying to query documents that were created 24 hours ago or earlier. They have tried using the code `Query.lessThanEqual("$createdAt", date)`, but it is not working. They are asking for help on what they may be doing wrong and if there is a better way to achieve this.

try this:

TypeScript

Query.lessThanEqual("$createdAt", date),

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Join Discord

Get premium support

Join Appwrite Pro and get email support from our team.

Learn more

Recommended threads

Need support?

Join our Discord

Get premium support