Filter Field on date of type year/month use greater than instead of equals

1

I added a filter field on a datetime column.

When I put in the native sql query [[ AND {{ date_added }} ]] it shows only the records of that day and month. What I actually need is [[ AND date_added>={{date_added}} ]] which does not filter at all.

So is there a way to tell in [[ AND {{ date_added }} ]] that you need equal_or_after ?

Thanks

2

Hi @jkeppens
You cannot use Field Filters like that:
https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#the-field-filter-variable-type
And there’s a longer article on Field Filters here:
https://www.metabase.com/blog/field-filters/index.html

You should be using a simple Date filter instead:
https://www.metabase.com/blog/sql-template-variables/index.html