Get only the latest date from date filter

I use a date filter on my report and all my questions are made with this clause AND {{date_filter}}.
However, i have one question that will only need the end date of that filter. Is there a way to accomplish that? Either in metabase or SQL.

Hi @snirklebore
No, you would have to use a simple Date filter instead of a Field Filter.
https://www.metabase.com/learn/sql-questions/sql-variables

1 Like