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

TIMESTAMPDIFF between two status

edited Dec 13, 2022 7:11AM in Taleo Enterprise 6 comments

Content

Hello, 

I would like to calculate the number of days between two date from CSW status; 

I tried this formula : 

TIMESTAMPDIFF(SQL_TSI_DAY,(CASE WHEN "Submission CSW Status - Historical"."Historical Status Name" = 'A évaluer' THEN "Submission CSW Status - Historical"."Submission Historical Status Start Date" ELSE NULL END),(CASE WHEN "Submission CSW Status - Historical"."Historical Status Name" = 'Satisfait les qualifications de base' THEN "Submission CSW Status - Historical"."Submission Historical Status Start Date" ELSE NULL END))

 

But it seems does not work, I have no values. 

Do you know where is my error? Do you have an idea how can I try to obtain this number ? 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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