AZA: Consecutive Absence Report
We have a requirement to build an absence report for a specific absence type, report should pull the data if the duration of the absence is greater than or equal to 3 days. 3 consecutive days in a row regardless of if they enter 4/1/22, 4/2/22, 4/3/22 or 4/1/22-4/3/22. We were able to get the data for the second case which is 4/1/22-4/3/22 but we are finding it difficult to get the data if the absence is entered with individual entries on 4/1/22, 4/2/22, 4/3/22.
Does anyone had similar kind of requirement. Any inputs/pointe are much appreciated.
Thanks in advance