Once an effective date is set, it cannot be changed to ensure that the historical and transactional data remains accurate and consistent.
So to edit the effective date of a row in a table, you will need to add a new row with the new effective date and then delete the previous incorrect entry.
