Global Absence entry validation formula failed to restrict 4 weeks gap between 2 absence types
Hello Experts,
We have the requirement that "After parental leave, 4 weeks of work are required before self-certification sick leave can be used" and to achieve this the following logic is applied. But the entry validation is not working and sick leave is getting submitted after Parental leave
/*==========================================================FORMULA TYPE: Global Absence Entry Validation============================================================*/
DEFAULT FOR IV_START_DATE IS '4712/12/31' (date)DEFAULT FOR IV_END_DATE IS '4712/12/31' (date)DEFAULT FOR IV_TOTALDURATION IS 0DEFAULT FOR PER_ASG_START_DATE IS '4712/12/31' (date)DEFAULT FOR ANC_ABS_ENTRS_DURATION IS 0DEFAULT FOR ANC_ABS_TYP_NAME IS ' 'DEFAULT FOR ANC_ABS_TYP_DURATION_UOM_CD IS 'D'DEFAULT_DATA_VALUE FOR ANC_PER_ABS_ENTRS_ABSENCE_ENTRY_ID_ARR IS 0DEFAULT FOR ANC_ABS_ENTRS_ABSENCE_TYPE_ID IS 0DEFAULT FOR ANC_ABS_ENTRS_ABSENCE_STATUS_CD IS ' 'DEFAULT FOR ANC_ABS_ENTRS_APPROVAL_STATUS_CD IS ' 'DEFAULT FOR ANC_ABS_ENTRS_START_DATE IS '4712/12/31' (date)DEFAULT FOR ANC_ABS_ENTRS_END_DATE IS '4712/12/31' (date)