Adjust Seniority Date based on fast formula is not working for assignments -3 or above
We are using a fast formula to adjust the seniority date for original hire date. The fast formula is working for all assignments ending in -2 and below but anything -3 and above is not capturing the correct hire date. The date that should show for seniority date for this rule is 6/27/88 for all three instances.
/****************************************************************************
* Formula Name: IHN Seniority Date
* Description: This formula using the following context:
* EFFECTIVE_DATE, PERSON_ID, HR_RELATIONSHIP_ID, HR_TERM_ID, HR_ASSIGNMENT_ID
****************************************************************************/
default for SENIORITY_ADJUST_COMMENT is 'no adjustment'
default for SENIORITY_ADJUST_IN_DAYS is 0
default for SENIORITY_ADJUST_IN_HOURS is 0