News:

Support the VirtueMart project and become a member

Main Menu

Incorrect date and time in VM3 earnings report

Started by bssz, July 14, 2020, 21:13:10 PM

Previous topic - Next topic

bssz

Hey. I have a problem in time discrepancy in the Virtuemart> Reports menu item. When displaying a report on orders, the time for orders goes -3 hours. Joomla settings cost +3 hours. Due to this problem, overnight orders will be delivered the next day and will not appear in revenue. Has anyone encountered such a problem?
Installed VM 3.8.2

AH

yes the report does not consider the time of the order and adjust for database record written time and date vs local time/date
Regards
A

Joomla 3.10.11
php 8.0

bssz

Time is entered into the database in the format of the time zone +0, this is logical.  But how can I adjust these reports to my time zone, or to the time zone used by Joomla settings

AH

On the report - I have no ideas

Have you set timezone correctly in your php settings and in Joomla configuration?

If you have orders will be displayed and dates printed based on the function - vmJsApi::date(

Orders will therefore display correctly for local times vs server dbase time (assuming server is using UTC 0)

Regards
A

Joomla 3.10.11
php 8.0