I can't add a filter to my dashboard on a date variable. It says "A date variable in this card can only be connected to a time type with the single date option."
I've tried DATE_TRUNC('day', table.date) AS date and casting date to date but I still can't add the filter to date in the dashboard.