Back
Query.startswith problem
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
TypeScript
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?
TL;DR
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
