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

Days of Difference Between Requisition Created and Requisition Approval Requested

Accepted answer
edited Dec 13, 2022 7:07AM in Taleo Enterprise 1 comment


Formula Question


I am trying to figure out a way to calculate the difference in Days between Requisition Created and Requisition Approval Requested BY Req. Identifier when the following statements are true

1. Transaction Event Type equals to Requisition Created, Requisition Approval Requested

2. The earliest date of Requisition Created and the latest day of Approval Requested

Challenge: I don't know how to create a formula that could calculate the difference correctly while meeting two criterion.

Temporary Solution: I use MAX to sort out the latest date of "Approval Requested" in one column and MIN to sort out the "Created" date in a different column and do the calculation in Excel. 


Howdy, Stranger!

Log In

To view full details, sign in.


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