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
33
Views
2
Comments
edited May 23, 2018 3:15PM in Reporting and Analytics 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!