End Date advance absence entry

Summary:

We have a requirement to split the advance absence entry to a cut-off date and recreate the absence entry using cut-off date +1 using HDL for the open-ended absences

Ex: The sickness entry from 01-Apr-2023 to open-ended absence is to be split into two entries with the cut-off date being 15-Apr . After the split, we need two entries 01-Apr-2023 to 15-Apr-2023 and 16-Apr-2023 - Open-ended. As these entries are advance absence entries, the day-wise entries should be adjusted as per the new start dates and end dates.

Any suggestions would be greatly appreciated.

Content (please ensure you mask any confidential information):