I am not familiar at all with managing dates in a worldwide application !!
In the CMS, a table store some actions done by the visitors.
Users are in Belgium (GMT+1). Looking in the CMS screen, they are presented with the belgian time.
For the administrator, I have to present a summary (agglomerate) of the actions recorded, based on local dates. Lets say from monday 11/11 (0:00:00 local time) to wednesday 13/11 (23:59:59 local time). The administrator select start and end day on calendar and the 23:59:59 is added by code to the end date.
The function to retreive the data is in the backend. When I call the function, the date/time variable are modified (likely adapted to UTC time). These modified dates are used in the query.
My question is how the date is estimated in the query : UTC or local Belgian time?
Hi, sentiers5140 !!
I think that when you retrieve a date in the Wix backend, it is obtained in UTC.
Date calculations can be confusing no matter how many times you do them, so it might be a good idea to base things on timestamps or use date manipulation libraries like date-fns or date-fns-tz to handle the processing. 