Hello,

Please try to change to some other timezone and then set it back. If it is still the same, you can directly check your database for the saved dates in sma_sales table.

Thank you

I already did changed the timezone.

The problem is I have 3000+ sales recorded already and I cannot change the date manually

Btw, these are POS Sales

It is showing correct date in the database, but on the “POS Sales” the date is ahead of 6 hours. It is messing up the reports for daily sales and monthly sales

Hello,

If the date in the database is correct and you have updated the timezone then there shouldn’t be such issue. It should be same as it was on your previous server. I am not sure about the reason, did you check with your server admin for your server timezone? You can try to set the default timezone on your server.

Thank you

The date in the database is also wrong when moved to the new server. I am using xampp localhost. And changed the server time to show the correct timezone.

Here’s the situation, my last order from the database is dated 05/22/2024 - 21:00AM but when I moved the database and check phpmyadmin it shows 05/23/2024 - 06:00AM

Hello,

Exporting and importing database shouldn’t change date or time. Please check with your server admin as they can guide further.

Thank you

Actually it did. I tried moving it to a new cpanel and I experience the same thing. Please help

Contacted the support and i was told theres nothing wrong with the server.