Issue getting most recent/max date for "Offer Extended" Recruiting Event
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 returnedContent
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.