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 with Redwood for Oracle Cloud HCM   Begin Now

Calculate hire date

Summary:

Calculate the hire date considering rehire within 3 months

Content (required):

Hi All,

We need to calculate the hire date and years of experience in a report based on below below conditions:

1. If the employee is having only one hire record, we need to get the hire date of that record.

2. If the employee is rehired within in 3 months, again we need to use the hire date of the first hire.

3. If the employee is rehired after more than 3 months, we need to use the rehire date.

4. For Global Transfers we need to use the hire date of the first hire (unless a rehire) or rehire date.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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