Invalid report date

[kyrena]

Go to Reports > Sales > Invoiced, set Period to Month, set From to 01/01/2023 and To to 20/03/2023.

Result is something like that (1/1970):

Tested with OpenMage 19.5.0-rc2 and 20.1.0-rc2, with PHP 8.0.

[m-overlund]

Tested on 19.4.23 and PHP 8.1 with no issues

[elidrissidev]

Seems to be a regression in the latest RC releases.

[elidrissidev]

This issue was introduced in #2827, the Zend_Date override in app/code/core/Zend had a few additional lines that made the date parsing work.

[fballiano]

but #2861 seems to remove only Zend_Db related stuff no?

[elidrissidev]

Yeah it was a different one, updated comment.

[sreichel]

This issue was introduced in #2827, the Zend_Date override in app/code/core/Zend had a few additional lines that made the date parsing work.

Could you track it to a specific line?

[elidrissidev]

Could you track it to a specific line?

Somewhere in these lines https://github.com/OpenMage/magento-lts/blob/v19.4.23/app/code/core/Zend/Date.php#L2080-2085

Either they were removed in zf1-future, or they were added by the magento team to support a specific usecase.

[sreichel]

This has been added to Zend ... Shardj/zf1-future@c7a5cf6

                // (T)hh:mm
                if (empty($timematch)) {
                    preg_match('/[T,\s]{0,1}(\d{2}):(\d{2})/', $tmpdate, $timematch);
                }
                // (T)hhmm
                if (empty($timematch)) {
                    preg_match('/[T,\s]{0,1}(\d{2})(\d{2})/', $tmpdate, $timematch);
                }

(seems Magento used an oudated version of Zend_Date?!?)