i’ll see if i can replicate it and what’s going on

thanks

a) make sure your timezones are set correctly (wp->general->settings, as well as in the php.ini)

b)furthermore, i know of other plugins, that change/override/disregard the timezone settings and just use UTC for example. nothing i can do about other plugins messing around with or totally ignoring those settings.

Having said that, I know that with some/many plugins it tends to be better to use actual timezones (in the wordpress setup) like “london/europe” as opposed to “UTC -3” (or whatever would appropriate). certainly worth a try …

c) always a chance that this bit/behaviour is something my end.
however, in all events so far i have only ever found that other plugins mess this up or the timezones (wp / php.ini) are not set correctly

>But I think our database and webserver are both configured with different timezones.

that’ll be why then

>Can database or webserver settings have any effect on the report screen?
absolutely

first of all, the only times that actually get stored are the order and update time in the order table (as far as i remember anyway) and there is no calculation going on there as it just uses a mysql timestamp. (a bit more about this below)

secondly – and more importantly as far as i am concerned – consider the following:
store order time as UTC.
go to admin ->reports which – obviously – uses the times stored in the order table to figure out when was what order done.
if UTC, convert the timestamp to WP time with some function, multiply by 1000’s
if *not* UTC, do not run a function , multiply function to run by == 0
(same would be the case for various other places, just not that excessively)

furthermore. the order time SHOULD be fixed to the timezone here in my book.
if i make an order at 4PM at the timezone we are in it was still at 4PM 10 months later when the server moves elsewhere and their timezones are different, not suddenly at 6PM or 2PM or whatever

although nothing to do with reports, there seems to be a transient issue with wordpress under certain circumstances
https://wordpress.org/support/topic/set_transient-seem-to-use-server-time-regardless-of-timezone

lastly, i have also seen plugins that totally disregard other plugins and overwrite/change wp time with their own stuff screwing everybody else. So it does not make any difference what time YOUR plugin is using as someone else thinks THEIR time should be used

in any case, all of the above is not ever a problem if the timezones match.
i know of some hosting companies arguments , that the server time should be utc because visitors to the site come from all parts of the world. as far as i am concerned, this is complete rubbish as the server itself (and the shop that is running on that server) is NOT in different parts of the world but in a very distinct location

regarding the mysql timestamp. currently it inserts the time into the timestamp column by itself so to speak (there’s not insert time() into timestamp_column)

one could probably change that to do insert wp_time into timestamp_column which should at least overcome the times saved are being wp_times , regardless of php.ini settings.
i will mull this over for a bit

lol
>if UTC, convert the timestamp to WP time with some function, multiply by 1000’s

what i said there is of course nonsense.
one would recalc the current time to UTC once of course and then compare the db entries as opposed to recalculating every db entry and comparing them to current time..
anyway though, the rest still applies