Hi @karan247
I don’t quite understand what you’re trying to do, but there’s a very big difference between Field Filters, which supports multiple date-formats, but is fairly strict in usage - and simple Date filter, which only allows single-dates, but variable is more flexible.
Have a read here:
https://www.metabase.com/learn/building-analytics/sql-templates/field-filters.html
https://www.metabase.com/learn/building-analytics/sql-templates/sql-variables.html