Error Message occurs while changing the hire date using HDL

Hi,

We're trying to change the hire date of a person record via HDL(Worker.dat)

HDL Code used:

SET PURGE_FUTURE_CHANGES N

METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|LegalEmployerName|NewStartDate

MERGE|WorkRelationship|FUSION|XXXX|YYYY|ABC|YYYY/MM/DD

Wherein

SourceSystemId = (Select *from per_periods_of_service WHERE Person_ID = '123456789') - which results in POSID

PersonId = (Select *from PER_ALL_PEOPLE_F Where Person_Number ='000') - which results in PERSONID

NewStartDate - any date

While we run the HDL code, we're getting the below error:

The Effective Start Date attribute must be on or before the Effective End Date attribute.