const minDate = new Date();
minDate.setFullYear(minDate.getFullYear() - filterData?.maxAge);
const maxDate = new Date();
maxDate.setFullYear(maxDate.getFullYear() - filterData?.minAge);
Query.between("birthdate", minDate.toDateString(), maxDate.toDateString())
// Query.between("birthdate", minDate, maxDate)
AppwriteException: Invalid query: Query type does not match expected: datetime
Query.between only accept number or string
Query.between: (attribute: string, start: string | number, end: string | number) => string
How can i handle with this kind of situations if i want to get docs between 2 dates? Any idea?
Known issue: https://github.com/appwrite/appwrite/issues/5650
This issue for only the type of float I also commented on related issue with the datetime .Thanks
[CLOSED] Any solutions for Query.between() with datetime
Recommended threads
- Inviting members while SMTP is disabled ...
Issue: https://github.com/appwrite/console/issues/3125 PR: https://github.com/appwrite/console/pull/3126
- Appwrite Sites: ERR_TOO_MANY_REDIRECTS o...
So, my domain was working perfectly fine with Vercel. I was using cloudflare CDN (still am) but CNAME was DNS-only. I switched over to appwrite, CNAME is still ...
- Invalid type for attribute 'email': emai...
I'm using the node-appwrite SDK to create a table, the column payload looks like this: ```json [{"key":"email","type":"email","required":true, "size": 512}] ``...