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
- MariaDB refuses to connect to appwrite
Earlier, I tried updating my Appwrite version from 18.1.x to the latest release because my Flutter package required it to function properly. I used the official...
- Custom API domain is unreachable
Earlier my custom api domain was working fine. Now it seems to be offline without a trace a few hours later. I didn't change anything, all the relevant DNS reco...
- "Invalid console fingerprint" when unpau...
I've tried logging out and logging back in, still can't figure out why this is happening.