Issue getting most recent/max date for "Offer Extended" Recruiting Event — Cloud Customer Connect
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

Issue getting most recent/max date for "Offer Extended" Recruiting Event

edited Aug 11, 2020 2:22PM in Reporting and Analytics for HCM 9 comments

Summary

I have an ORC report where I need to return only the most recent/latest date for a specific recruiting event (offer extended) but I am getting multiple rows returned

Content

Hello,

I have an OTBI analysis where I need to provide the most recent date when an ORC offer was extended to the candidate.  In some cases, an offer may be extended and then reverted, reworked and re-extended, which creates multiple events of the type "OFFER_EXTENDED" in the database for the same job application.  My challenge is that, applying a MAX on my CASE statement for this field does not limit the output to just the most recent date but rather returns NULL for the Date Offer Extended field for all records.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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