Retention policies on Sales Header Archives


we have auto-archive enabled for our sales orders.
I read that I can create a retention policy that deletes the older version a sales order archive while keeping the most current version.

When I set everything up, it’s not working because the default field it’s looking at doesn’t get populated on the auto-archive. I can’t change the default field.

Anyone has any idea on how to fix it? Do I need to code my own retention policy and change the date field?

Thank you in advance.

Actual retention policy

Actual value of that field for a sales order archive