Areas of Responsibility (AOR) dates

Summary: Is it possible to have the end date automatically populate if the person has termed from the company?

Content (required): When someone leaves the company that had responsibility for a department, the "to date" field does not populate with their term date, which causes havoc with reports, workflows, etc. Is there a way to have this field auto-populate?

Version (include the version you are using, if applicable): 22A

Code Snippet (add any code snippets that support your topic, if applicable):