Incorrect Syntax near the keyword End

Ramco Ramco

SET @frDate= "01/04" +  (CASE WHEN (MONTH(GetDate())) <=3 THEN convert(varchar(4),
  YEAR(getDate())-1) else "01/04" + convert(varchar(4),YEAR(getDate()) End

Thanks

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal Joshi2y ago

Accepted answer

Hello Ramco,

Please try the below code. it's not working due to closing bracket is missing ')'

SET @frDate= '01/04' +  (CASE WHEN (MONTH(GetDate())) <=3 THEN convert(varchar(4),
  YEAR(getDate())-1) else '01/04' + convert(varchar(4),YEAR(getDate())) End)

Thanks

Tuhin Paul2y ago

SET @frDate = '01/04' + 
    CASE 
        WHEN MONTH(GETDATE()) <= 3 
            THEN CONVERT(VARCHAR(4), YEAR(GETDATE()) - 1)
        ELSE '01/04' + CONVERT(VARCHAR(4), YEAR(GETDATE()))
    END;

Replaced double quotes with single quotes for string literals.

Sachin Singh2y ago

Check this

DECLARE @frDate VARCHAR(10);

SET @frDate = '01/04' +
  (CASE
    WHEN MONTH(GETDATE()) <= 3 THEN CONVERT(VARCHAR(4), YEAR(GETDATE()) - 1)
    ELSE CONVERT(VARCHAR(4), YEAR(GETDATE()))
  END);

SELECT @frDate AS Result;

Jayraj Chhaya2y ago
The syntax error is caused by the incorrect usage of double quotes (") instead of single quotes (') to enclose the string literals in the code. In SQL, string literals should be enclosed in single quotes.
```
  DECLARE @frDate VARCHAR(150)
  SET @frDate = '01/04/' + (CASE WHEN (MONTH(GetDate())) <= 3 THEN CONVERT(varchar(4), YEAR(GETDATE()) - 1) ELSE '01/04/' + CONVERT(varchar(4), YEAR(GETDATE())) END)
  PRINT @FrDate
```
By replacing the double quotes with single quotes, the syntax error is resolved.