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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

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

Case Statement including Date logic is not working

edited Dec 13, 2022 7:02AM in Taleo Enterprise 5 comments

Summary

I would like some help with an issue i'm having on a case statement using date logic

Content

Hi All, I'm looking for some guidance on an issue I'm having with a case statement. I've created a case statement to bucket our step/statuses. This is working perfectly fine. 

case when "Submission CSW Status - Current"."Current Status Name" in ('Rejected','Candidate Declined') then 'Offer Rejected/Declined'  

when "Submission CSW Status - Current"."Current Status Name" in ( 'Hire - DO NOT Interface New Hire Data', 'Hire - Interface New Hire Data', 'Hire - DO NOT Interface New Hire Data ', 'Hire - Interface New Hire Data ') then 'Hires' 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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