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
- Function issue
Hi,idk whats wrong with my function but i made some changes to the env var and made sure they saved then i redeployed it,but then after it redeeployed it asked ...
- Can't resume paused project
I have logged in in incognito, done the email verification and still get the invalid fingerprint error. What's the issue.
- I am currently seeking opportunities as ...
Hey! 👋 I'm a Shopify guy. Been building stores for 8+ years. Still haven't lost my mind. Barely. I make stores that don't suck fast, smooth, and actually built...