how can i use date range filter when i write sql-parameters

such as i want use

[[where “date” between {{begin_date}} and {{end_date}}]]

截图

Hi @kkxxr66573
You can use Field Filter and map it to your date field and change the query to this:

[[where {{date_filter}}]]

https://www.metabase.com/docs/latest/users-guide/13-sql-parameters.html#the-field-filter-variable-type