How to write a Native query question with in between field filter?

Get Help
1

Hello, I've been trying to write native queries ant this seems to stumble me quite a bit.
Here's what I'm trying to do (attached a pic).
Screenshot_1
Any Ideas what I'm doing wrong? ;/
PS:. I'm using Mysql

2

Hi @Martynas
That’s not how Field Filters are used:
https://www.metabase.com/blog/field-filters/index.html
Your BETWEEN-clause is using Number filters, so that looks okay, but you cannot do that on multiple columns.

1 Like