You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to count User-Defined Table Values to use in Fast formula?

Received Response


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.

Content (required):

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

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!