Message error for date query

select * from users
WHERE (DATE(created_at) BETWEEN DATE(’{{ 01/01/21 }}’) and DATE(’{{ 20/01/21}}’))

I GET THIS MESSAGE : Error running query: missing values for start, end parameters

can someone help me please

That’s not how parameters work.

Your query should look like this:

select * from users
WHERE (DATE(created_at) BETWEEN DATE(’{{ date_param.start }}’) and DATE(’{{ date_param.end}}’))

Then you would enter the date range using a widget beneath the query editor. If you just need to hardcode dates into your query then you can just remove the double curly braces {{ }}.