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

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).


Any Ideas what I’m doing wrong? ;/
PS:. I’m using Mysql

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