Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Absence entry validation formula to check past dated leaves are on public holiday or weekend — Cloud Customer Connect
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

Absence entry validation formula to check past dated leaves are on public holiday or weekend

Received Response
13
Views
1
Comments

Summary:

We have a qualification plan where an employee is entitled 10 days in a rolling back period.

Employee works Mon-Fri.

  1. historical leave applied from 20 june 2022- 27-june 2022 = 6 days
  2. Employee applies new leave from 22 june 2023-24 june 2023 = 2 days
  3. 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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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