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

how to get the number of absences between two dates

Accepted answer


Content (required):

Hi Experts,

We have a requirement as below.

Type B absence can be taken only after 3 days of the End date of Type A absence. I used below code to get the count of absences and tried to add that in a IF condition. But this code only fetches the count if there's an absence record (with start date and end date) between these dates. I just want to get the End Date of Type A absence to perform validation.

How can I achieve this?

Thanks in advance!

Version (include the version you are using, if applicable):

Howdy, Stranger!

Log In

To view full details, sign in.


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