Range date filter for Metabase SQL query

Feedback and Requests
1

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,
BP

2

Hi @brunolnetto
It would be easier if you posted the query, but it sounds like you're not using Field Filters:
https://www.metabase.com/learn/building-analytics/sql-templates/field-filters.html