Author Topic: Incorrect date and time in VM3 earnings report  (Read 572 times)

bssz

  • Beginner
  • *
  • Posts: 2
  • A beginner
Incorrect date and time in VM3 earnings report
« 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

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3262
  • VirtueMart Version: 3.8.4
Re: Incorrect date and time in VM3 earnings report
« Reply #1 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
regards
A

Joomla 3.9.20
php 7.3

bssz

  • Beginner
  • *
  • Posts: 2
  • A beginner
Re: Incorrect date and time in VM3 earnings report
« Reply #2 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

AH

  • Global Moderator
  • Sr. Member
  • *
  • Posts: 3262
  • VirtueMart Version: 3.8.4
Re: Incorrect date and time in VM3 earnings report
« Reply #3 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)

regards
A

Joomla 3.9.20
php 7.3