Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
TIMESTAMPDIFF between two status
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 ?
1