Absence Entry Validation: Duration is not correctly calculating
Summary:
Absence Type = Work From Home_
Requirement: Employees should be able to capture leave only once a week. There is no payroll deduction involved. So, we created an absence type and attached the fast formula below. However, it is not working as expected.
/* =========================================================================
FORMULA NAME: ANC_ABS_WEEK_LIMIT_VAL
FORMULA TYPE: Global Absence Entry Validation
DESCRIPTION: Restricts employee from booking > 1 day of Work From Home
leave per calendar week (Mon-Sun).
========================================================================= */
DEFAULT FOR IV_START_DATE IS '4712-12-31' (date)
DEFAULT FOR IV_END_DATE IS '4712-12-31' (date)
DEFAULT FOR IV_DURATION IS 0
DEFAULT FOR IV_TOTALDURATION IS 0