how to get the number of absences between two dates

Summary:

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):