Every article has a Review Date (not the Valid To Date) and we are experiencing a problem that when an article reaches it's valid to date, the previous version state changes to Review and is stuck.
Example - XYZ article version 1.0 reached it's Review Date of 5/29/24. The article is checked out on 5/31/24, the review date updated and re-published to version 2.0.
Version 1.0 is now stuck in Review and there is no option to approve (because it has an outstanding review date) and cannot be checked out to update.
So now we have Version 1.0 that is Review state and version 2.0 that is Published. We have metrics tied around how many articles are in review, so we need some help on figuring out why this is happening when an article reaches/goes past it's review date.
