Query to fetch end date in custom audit report

We have created a custom audit report that shows new and old values based on audit tables on external bank accounts.

The problem is that if we end date the bank account on the customer, the end date is not fetched.

What do we need to do in order to fetch the end date?

Thanks in advance.