4
Answers

Incorrect Syntax near the keyword End

Photo of Ramco Ramco

Ramco Ramco

1y
514
1

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)