Ramco Ramco

Ramco Ramco

  • 442
  • 3.4k
  • 515.6k

Incorrect Syntax near the keyword End

Feb 1 2024 6:06 AM

Hi

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


Answers (4)