Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
MAX "Profile Passport"."Profile Service Status Log Date"
Summary
MAX "Profile Passport"."Profile Service Status Log Date"Content
I am trying to get max date (latest activity date) and the results status ("Profile Passport"."Profile Service Request Status" which I have in a separate column) and I tried both of these max statements but I am still getting two rows of data with the two different dates for an individual. Anyone have any thoughts
MAX ("Profile Passport"."Profile Service Status Log Date"
by "Candidate Identification"."Candidate Identifier")
MAX ("Profile Passport"."Profile Service Status Log Date"
by "Profile Passport"."Profile Service Name")
Tagged:
0