Range date filter for Metabase SQL query

Hi folks,

I create a query with date range filter easily with Metabase UI. However, when I write a query in SQL and add a "where" clause with {{date_field}}, the default values are the dates itself and not the prior UI options, like "previous 30 days". What do I do wrong?

Best regards,

Hi @brunolnetto
It would be easier if you posted the query, but it sounds like you're not using Field Filters: