Case Statement Length of Service

Summary:

I would like some assistance on a case statement calculating length of service.

Content (required):

I am creating a case statement that looks at the assignment status. If the employee is active, the service should calculate between the hire date and current date. If the employee is inactive, the service should calculate between the hire date and termination date. I have the below formula, but when I execute the analysis, I receive a SQL error message.

CASE WHEN ("Workforce Management - Work Relationship Real Time"."Worker"."HR Status" = 'Active') THEN (TIMESTAMPDIFF(SQL_TSI_YEAR, "Workforce Management - Work Relationship Real Time"."Worker"."Employee Hire Date", CURRENT_DATE))