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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Formula for Days Open in OTBI for Job Requisitions

in Recruiting, Opportunity Marketplace

Summary:

I'm creating an OTBI report for Posted Requisitions. Currently I'm using Job Requisition Open Date from the Recruiting - Recruiting Events Real Time and to get Days Open from that date I'm using this formula: TIMESTAMPDIFF(SQL_TSI_DAY,"Job Requisition - Dates"."Job Requisition Open Date",CURRENT_TIMESTAMP).

I would like to change this so that the "Job Requisition Open Date" reflects the last update or most up to date date posted. And then have the "Days Open" formula be that Updated Posted Date and Today's Date. How would I go about doing this?

Content (please ensure you mask any confidential information):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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