Length of Service Banding

Content

I am trying to Band together number of employees within certain Length of Service Banding.
Our Length of Service is from "Enterprise Seniority Date"

But the Report is erroring and i am unsure as to why, any advice please.    (Coding is Below)

 

CASE  WHEN YEAR(CURRENT_DATE) - YEAR(“Worker”.”Enterprise Seniority Date”) - (CASE WHEN (CAST(MONTH(CURRENT_DATE) AS INT)*100) + CAST(DAY(CURRENT_DATE) AS INT) < (CAST(MONTH(“Worker”.”Enterprise Seniority Date”) AS INT)*100) + CAST(DAY(“Worker”.”Enterprise Seniority Date”) AS INT) THEN 1 ELSE 0 END) <= 5 THEN '00 - 05' WHEN YEAR(CURRENT_DATE) - YEAR(“Worker”.”Enterprise Seniority Date”) - (CASE WHEN (CAST(MONTH(CURRENT_DATE) AS INT)*100) + CAST(DAY(CURRENT_DATE) AS INT) < (CAST(MONTH(“Worker”.”Enterprise Seniority Date”) AS INT)*100) + CAST(DAY(“Worker”.”Enterprise Seniority Date”) AS INT) THEN 1 ELSE 0 END) BETWEEN 06 AND 10 THEN '06 - 10' WHEN YEAR(CURRENT_DATE) - YEAR(“Worker”.”Enterprise Seniority Date”) - (CASE WHEN (CAST(MONTH(CURRENT_DATE) AS INT)*100) + CAST(DAY(CURRENT_DATE) AS INT) < (CAST(MONTH(“Worker”.”Enterprise Seniority Date”) AS INT)*100) +