Ramco Ramco

Ramco Ramco

  • 426
  • 3.5k
  • 569.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)