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

How to use MAX Date in OTBI

Accepted answer
655
Views
8
Comments
edited Apr 22, 2021 12:11AM in Reporting and Analytics for HCM 8 comments

Content

Hi 

I'm getting multiple work relationship records, I would like to return only the latest work relationship record.  How can use MAX function to select the latest row?

ex. we have partners and there is Partnership Start Date. if partner get promoted to next level I'm getting 2 rows for same partner.

Name      Partner Level   Start Date
abc          Level1               12/12/2019
  Level2 12/12/2020
xyz level3 12/12/2020
     

So in this ex, I want one row for abc with start date 12/12/2020.

 

 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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