Timezone problems with dashboard today's revenue

[hanshenrikchr]

Which component is this issue related to?

Umbraco Commerce (Core)

Which Umbraco Commerce version are you using? (Please write the exact version, example: 10.1.0)

16.3.2

Bug summary

Hi!

It seems there’s a difference between the time used for displaying “today’s revenue” and the data shown under “analytics”. We have a customer who receives a lot of orders around midnight (01:00 Danish time), and on the dashboard we see the following:

However, if I go into the analytics section and set it to show data for the same day (today’s date), we see the following:

Specifics

No response

Steps to reproduce

Ensure you have orders created shortly after midnight (e.g. between 00:00–01:00 in your local timezone).
Check the “Today’s revenue” figure on the dashboard.
Compare it with the Analytics view when filtering for the same calendar day.

Expected result / actual result

I would expect the data from the dashboard would match the data from the analytics, so we show the correct data in the dashboard

Dependencies

No response

[mattbrailsford]

I guess the question is, which one of those is correct?

[hanshenrikchr]

In my opinion the correct one is the one in the analytics area since the orders was actually placed after midnight 24/10-25)

[mattbrailsford]

Cool, I've pushed a 16.3.3--preview.2 to our nightly feed with what I think is the right fix. Would you be able to give it a test?

[mattbrailsford]

16.4.0 has now been released which contains the fix for this issue.