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
44
Views
2
Comments
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")

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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