Parse Syntax error ,can anyone guide me what is going wrong here

[Sajid1]

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

[Debayan]

Hi @Sajid Thavalengal Rahiman​ , Have you followed the recommendation given above? Also, could you please paste the whole error with the code?

[Sajid1 · Accepted solution]

My bad, I had missed with the syntax and rewrote the first condition in a alternate manner and it fixed it. Thanks for your time to go through the post

The update code is for your reference

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

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 

[Debayan]

Glad to know! Thanks.

[Kaniz]

Hi @Sajid Thavalengal Rahiman​ ​, It would mean a lot if you could select the "Best Answer" to help others find the correct answer faster.

This makes that answer appear right after the question, so it's easier to find within a thread.

It also helps us mark the question as answered so we can have more eyes helping others with unanswered questions.

Can I count on you?