How to add new PersonAddress Effective date

Summary:

We are trying to update Person Addess via HDL.

We can end date the existing row, but the new row fails.

Also the end dated row creates a new effective date rows with the old information.

First attempt

METADATA	PersonAddress	PersonNumber	AddressLine1	AddressLine2	TownOrCity	PostalCode	Region2	Country	AddressType	PrimaryFlag	EffectiveStartDate	EffectiveEndDate
MERGE	PersonAddress	30038905	109 S Oak St	Apt 2	Brookland	72417	AR	US	HOME	Y	2023/08/14	2026/10/19
MERGE	PersonAddress	30038905	3705 keenland dr		Jonesboro	72404	AR	US	HOME	Y	2026/10/20	4712/12/31

Second Attempt

METADATA	PersonAddress	PersonNumber	AddressLine1	AddressLine2	TownOrCity	PostalCode	Region2	Country	AddressType	PrimaryFlag	EffectiveStartDate	EffectiveEndDate
MERGE	PersonAddress	30038905	109 S Oak St	Apt 2	Brookland	72417	AR	US	HOME	Y	2026/10/20	2026/10/21
MERGE	PersonAddress