Need to exclude Sat and Sun from Leave Apply

[ssalipk]

Hi,

Need to exclude Sat and Sun from Leave Apply, the requirement is when user apply for leave and when he enter days like 1 to 10 the system should exclude sat and sun in this duration and Calculate Duration Button should show the remaining days in Total Field. In which formula or PL/SQL script should open to amend this. Currently system is only excluding Sunday.

Regards,

[eng_ahmad_2007]

Dear Ssali,

You should modify the Fast Formula "BG_ABSENCE_DURATION" of type QuickPaint. If you need further explanation, feel free to post.

Best Regards,

Ahmad Ghanem

[mamajid]

Dear Ssali,

Modify the Fast Formula as Ahmed said their is a function (not remembering exactly) some thing like calculate days or else in BG_Absence_Duration formula. Modify it and use calculate working days to exclude sat and sun. You can find the exact name of function to be modified in BG_absence_duration fast formula in Fast formula user guide.

Regards

Majid

[Alihsyed]

You can also use work schedules in order to exclude holidays..