Overlapping of leave days

hi,

I need to get the leave days where the days are over lapping. This will be only filtered one month at a time

If i filter by the month of December i should get the result below
and if i filter by the month of January i should also get the below results.

This

“EmployeeNumber”: “1000000”,
“FullName”: “john Doe”,
“LeaveBucket”: “leave-priority”,
“LeaveType”: “Annual”,
“LeaveCompanyRun”: “202312”,
“NoOfDays”: 17,
“TimeOfDay”: null,
“Comments”: “”,
“Reference”: null,
“LeaveReason”: null,
“LeaveStartDate”: “2023-12-27T00:00:00+02:00”,
“LeaveEndDate”: “2024-01-19T00:00:00+02:00”,
“LeaveStatus”: “Approved”,
“LeaveTransactionType”: “Leave Application”,

Hey @technical-astronom13 :wave:

Welcome to the Postman Community! :postman:

This is a very contextual questions using an API that only you currently know about - Can you breakdown the flow in a more formal manner to give you the best chance of receiving assistance here.

Also, if you’re posting example responses, please ensure that these are valid JSON, the extract you posted could be part of an array of object or a single object - the way would access those would be different.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.