This update fixes an issue where date-based order reports (specifically using the 'most_recent' formula) were displaying unordered results. The change ensures that string-type external values are correctly sorted by date, resolving inconsistencies and improving the accuracy of financial reporting. This impacts how recent order data is presented.

Ensure string-type external values are correctly sorted by date when using the "most_recent" formula.
This resolves an issue where values appeared unordered, especially for expressions using the "From the very start" period.

task-5951888

Forward-Port-Of: odoo/enterprise#115275
Forward-Port-Of: odoo/enterprise#113837