How does the Is Between [$between] filter work?

Does anyone know how to use the [$between] filter? I’ve reviewed the documentation and searched around the web but can’t find anything explaining how the Is Between filter works.

Hey there :slight_smile: ,

In REST, you have to use between as below:
https://www.siteurl.com/api/tablename?filters[jobPrice][$between]=100&filters[jobPrice][$between]=250

Hope this helps you.
Thanks

Thank you for the response but I was hoping it worked differently. I was thinking I could check if a number was between two different fields.

Something like this:

/api/tablename?filters=1600[$between][start_time][$and][end_time]

I’m currently doing this with less than and greater than. Just seems like a lot to check:

/api/tablename?filters[$and][0][hours][start][$lt]=1600&filters[$and][1][hours][end][$gt]=1600