Hi, i have a problem:
const result = await database.listDocuments(envs.DATABASE_ID,envs.COLLECTION_ID,[Query.startsWith('date', '2025-04-01')])
this one doesnt work
const result = await database.listDocuments(envs.DATABASE_ID,envs.COLLECTION_ID,[Query.startsWith('date', '2025-04-01T22:03:00.000+00:00')])
and this one does, i dont know why? I need first one to work ofc. Since its startsWith i expect it to work?
update
const startOfDay = ${date}T00:00:00.000+00:00; // Start of the day
const endOfDay = ${new Date(new Date(date).setDate(new Date(date).getDate() + 1)).toISOString().split('T')[0]}T00:00:00.000+00:00;
[ Query.greaterThan('date', startOfDay), Query.lessThan('date', endOfDay) ])
this seems to work but i still dont undestand why first approach is not working, this is working for almost everyday
Recommended threads
- Quota not resetting
hi, im using appwrite's free tier plani hit my read limts last month and the billing cycle said it would reset on june 4th but that is today, the billing cycle ...
- Student plan issue
I am using GitHub student plan, I even got access to appwrite's mock phone number. but when I try to use it, it says the phone number limit has reached
- DB Relational Table Request
Hi, I'd like to suggest a rewording of the relationships between tables. - Current wording: storeOperatingDays can contain one storeId ...