xueOriginal post
Rank 3: Container
TypeScript
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)Plain text
AppwriteException: Invalid query: Query type does not match expected: datetimeQuery.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?
Summary
Title: [CLOSED] Solutions for Query.between() with datetime
I want to use Query.between() with datetime, but it only accepts number and string. I tried to use it with datetime and got an error "AppwriteException: Invalid query: Query type does not match expected: datetime".
Known issue: <https://github.com/appwrite/appwrite/issues/5650>
Here is the code snippet I tried:
```typescript
const minDate = new Date();
minDate.setFullYear(minDate.getFullYear() - filterData?.maxAge);
const maxDate = new Date();
maxDate.setFullYear(maxDate.getFullYear() - filterData