How to count User-Defined Table Values to use in Fast formula?
We are trying to use UDT in a Fast formula to get Holiday dates in the current year, the reason to use a custom table is that the delivered function GET_PAY_AVAILABILITY did not work as expected. Thus we want to fill an array from UDT and then later use it in fast formula.
The function "GET_PAY_AVAILABILITY" is not considering the weekend based on employee's work schedule.
We applied for 28-Apr-2022 (Thurs) to 30-Apr-2022 (Sat) for an employee who has Monday off in his Assigned Work schedule. (Person Number 11854)
Holiday (29-Apr & 30-Apr)
1. GET_PAY_AVAILABILITY ('ASSIGN',l_abs_sd,l_abs_ed,'Y', 'Y', 'Y', 'N', 'D')