Update previous record based on new entry?

Question

How can i update a previous record "End Date field" when i enter a new record?

the previous "End date " field should get today's date

 

 

 

Thank you