You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Case Statement Length of Service

Accepted answer


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))


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!