How to pass two values to _between operator?

user_11993949 0
Viewed 106

"You must specify 2 values for the whereBetween clause" BUT how?

I am currently using the version: 9.0.0-rc.42

Error message "The filter value for "_between" has to be a string, number, or boolean"

filter: {
          date: {
            _between: ["2021-01-24", "2021-02-23"],
          },
        },
directus
2 Answers

Your example is correct, there was a bug in Directus' query validation for the _between operator (fixed in 5908822, released in v9.0.0-rc.43).

user_48592110

Can you try the value as comma seperated string.

_between: "2021-01-24,2021-02-23"
user_900160
Related