create a query that returns the first record
use that query as the basis for an append query and append the record
use same first query as the basis for an update query; set the value of Retired Date to whatever the amended value will be. Also set Acquired Date to that value.
OR
copy the record(s) to the clipboard
paste append to the table
create the update query but use whatever date value is required (this case, it would not reference the first query as you wouldn't need it).
The info you provided is somewhat sketchy. I'm assuming there'd be no data integrity violations and that you're not using a form, and that there's only one record to copy.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.