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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

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

CSW step/status move date formula help

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

Summary

Trying to create a CSW date move formula for each candidate ID by req. ID

Content

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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