Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Absence entry validation formula to check past dated leaves are on public holiday or weekend
Summary:
We have a qualification plan where an employee is entitled 10 days in a rolling back period.
Employee works Mon-Fri.
- historical leave applied from 20 june 2022- 27-june 2022 = 6 days
- Employee applies new leave from 22 june 2023-24 june 2023 = 2 days
- rolling period would be from 23 june 2022 - 22 june 2023.
23 june 2022 is an inbetween date in point 1.
So we want to know , how many days in the point 1 duration actually falls between 23 june 2022 - 27 june 2022 ?
23 june 2022 - 27 june 2022 = 3 working days ( checking manually in calendar)
This will helps us identify how many entitlements have been used and how many pending.
Thanks,
Content (required):
We have a qualification plan where an employee is entitled 10 days in a rolling back period.
Tagged:
0