GET_ABSENCE_DAYS_PER_TYPE function returns the weekends and whole days

Summary: Not to consider weekend days while using the GET_ABSENCE_DAYS_PER_TYPE function and not to consider half-days as whole days while using the same function

Content (please ensure you mask any confidential information): Hi All,

We have a requirement to bring in the total leaves taken for a particular absence type during the Plan cycle on the WFC Plan worksheet column. For example: the Plan cycle is between 01-Jan-2023 and 31-Dec-2023. Then bring in the total number of leaves taken during this period onto a custom User-Defined Column on the Worksheet display.

I have created a fast formula of type “Default and Override” wherein I am using the function “GET_ABSENCE_DAYS_PER_TYPE” which returns the calendar days between the l_abs_start_date and l_abs_END_date parameters supplied in the function.