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

CSW step/status move date formula help

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


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



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.


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