Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
MAX "Profile Passport"."Profile Service Status Log Date" — 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

MAX "Profile Passport"."Profile Service Status Log Date"

Accepted answer
40
Views
2
Comments
edited Oct 14, 2015 5:49PM in Reporting and Analytics Taleo Enterprise 2 comments

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")

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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