Select case WHEN {{ Month }} = 0 then add_months(current_date(),-13 ) else

WHEN {{ Month }}> month(add_months(current_date(),-1)) then add_months(to_date(concat(year(current_date())-1,'-',{{Month}},'-',1)),-13)

             else add_months(to_date(concat(year(current_date()),'-',{{Month}},'-',1)),-13) end dt

Here Month is a parameter with dropdownlist having values from 0-12. However, while executing the sql, getting parse_syntax_error

The error is pasted below

[PARSE_SYNTAX_ERROR] Syntax error at or near '0'line 1, pos 17

== SQL ==

Select case WHEN 0 = 0 then add_months(current_date(),-13 ) else

-----------------^^^

WHEN 0> month(add_months(current_date(),-1)) then add_months(to_date(concat(year(current_date())-1,'-',0,'-',1)),-13)

             else add_months(to_date(concat(year(current_date()),'-',0,'-',1)),-13) end dt LIMIT 1000