how to get the number of absences between two dates
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):