Multi-date filter for dashboard version

How do I use filters for multiple dates in the dashboard?For example, how to write sql?

I don’t understand “multi-date”, do you mean ranges? If yes, then you just need to return a date column.
Just for reference, this is the English dashboard time filter options on 0.31.2

yes,I understand.

How to write sql query statement with date range filter?
Can you give an example?
select nick,dt from demo where dt={{dt}};
Is the sql query with a date range written like this?

Correct. It just needs to return a date column.

I still don’t quite understand, I hope you can give an example of the actual sql query statement.


SELECT "name", "date" FROM "table" WHERE {{filter}}

It’s a lot easier, if you post your queries.