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.
CSW step/status move date formula help
Summary
Trying to create a CSW date move formula for each candidate ID by req. IDContent
Hello,
I'm trying to create a date formula for a historical step/status move by candidate ID AND req. ID. Please see below what I have come up with so far, I can only see to use the "By" phrase for just 1 variable either candidate ID or req. ID but not both.
MAX(CASE WHEN "Submission CSW Status - Historical"."Historical Status Name" In (' Upload to PS Successful','Transfer to Peoplesoft Successful','Transfer to PeopleSoft Successful','Transfer to PeopleHUB Successful') THEN "Submission CSW Status - Historical"."Submission Historical Status Start Date" END by "Requisition Identification"."Req. Identifier" by "Candidate Identification"."Candidate Identifier")
Tagged:
0