Some orders not displaying on the admin when filtering by date

[Yannis D]

Hi everyone,

Having set the Magento timezone to Greece/Athens I can view orders without any issues at the orders grid, but when I'm using a filter to view a single day, the orders that were placed between 00:00 and 03:00 (Greece/Athens is GMT+3 and I guess that it is related somehow) are not there. Any ideas?

Regards

Yannis

[Manish Mittal]

@Yannis D

Can you check once your database cause it seems timezone issue.

Check expected orders date in Sales_order table in database.

[Yannis D]

@Manish Mittal thank you for your reply.

Date and time at the db are in UTC. I tried hard, but I couldn't find a connection.

Yannis

[Manish Mittal · Accepted solution]

@Yannis D

This is Magento core issue and it will fix in Magento 2.3 release. 

https://github.com/magento/magento2/issues/16507