Date/DateTime input parameters should be formattable

Living in Japan where the start format is YYYY-MM-DD I’d like to make using Redash easier for our sales team by changing to input format in variables
image

Same issue.
There are many AWS Athena partitions using YYYY-MM-DD format in my DWH.

I just got this to work by formatting my query like so:

select sum(population) as population, week_starting from mytable
where week_starting > DATE('{{ week_starting }}')
group by week_starting

When checked the query in the Athena history, it showed the properly formated date in the where clause like ‘2020-01-04’

Screen Shot 2020-12-29 at 10.53.31 AM