Case Statement including Date logic is not working
Summary
I would like some help with an issue i'm having on a case statement using date logicContent
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'
0