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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Timediff from one status to another

edited Dec 13, 2022 7:09AM in Taleo Enterprise 2 comments

Content

Hi,

I am trying to get the time taken from one status to another.

Ex: Need to know what is the time taken from to be reviewed to Initiate ability test

  From To
Step Name Under Review  Assessment
Status Name To Be Reviewed Initiate Ability Test

Tried below and couldn't succeed. Kindly help.

MIN(TIMESTAMPDIFF(SQL_TSI_DAY,(CASE "Submission CSW Status - Historical"."Historical Status Name" WHEN 'To Be Reviewed' THEN "Submission CSW Status - Historical"."Submission Historical Status Start Date" END),(CASE "Submission CSW Status - Historical"."Historical Status Name" WHEN 'Initiate Ability Test' THEN "Submission CSW Status - Historical"."Submission Historical Status Start Date" END)))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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