Ramco Ramco

Ramco Ramco

  • 465
  • 2.8k
  • 395.1k

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)