Skip to content
Start project
Back

Query documents with datetime

  • 0
  • Databases
  • Functions
  • Web
  • Self Hosted
View on Discord
Philipp
29 Jan, 2024, 10:38

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.
kamal.panara
29 Jan, 2024, 10:57

try this:

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

Reply to this thread by joining our Discord

Reply on Discord

Recommended threads

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