
TypeScript
const oneDayAgo = new Date();
oneDayAgo.setDate(oneDayAgo.getDate() - 1);
const result=await database.listDocuments(databaseid, collectionId,[
Query.limit(50),
Query.orderDesc("$createdAt"),
Query.greaterThan("$createdAt",oneDayAgo),
Query.lessThan("$createdAt",today)
])
TL;DR
Developers are trying to fetch data from one day before, but the code is resulting in a server error. The issue may be with how the date is being handled. One suggestion is to use .toISOString(), and another idea is to check if the code works without queries.
Please explain more what your issue is, what errors do you have? Is there anything else we need to know?

it says server error

So a 500 I'm guessing. Can you try without queries and see if that works?

yes its not working after Query.greaterThan("$createdAt",oneDayAgo)

what does oneDayAgo variable result in?

its return a date

try using .toISOString()
Recommended threads
- Looking for Partner
I'm looking for partner for long-term collaborating. Of course, I'll pay for you. If you are interested, Please DM me.
- Hola equipo de soporte,
Hola equipo de soporte, Estoy desarrollando una Function en Appwrite Cloud con Node.js 22 y el siguiente package.json: { "name": "upload-whitelist", "type"...
- Looking for Partner
I'm looking for partner for long-term collaborating. Of course, I'll pay for you. If you are interested, Please DM me.
