VirtueMart Forum

VirtueMart 2 + 3 => General Questions => Topic started by: bssz on July 14, 2020, 21:13:10 pm

Title: Incorrect date and time in VM3 earnings report
Post by: bssz on July 14, 2020, 21:13:10 pm
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
Title: Re: Incorrect date and time in VM3 earnings report
Post by: AH on July 15, 2020, 09:41:52 am
yes the report does not consider the time of the order and adjust for database record written time and date vs local time/date
Title: Re: Incorrect date and time in VM3 earnings report
Post by: bssz on July 15, 2020, 11:15:46 am
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
Title: Re: Incorrect date and time in VM3 earnings report
Post by: AH on July 15, 2020, 11:57:01 am
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)