UTC replaced GMT in Universe - BOXI 4.1

general discussion
1

We’ve just installed a new instance of BOXI 4.1 and migrated the contents from our older 3.2 server, over. We now have a strange situation where, if we create a query and add a date field as a filter and select NOW as the date, it returns the UTC time not our GMT time. The server is set to GMT and displays the correct time (as does the SQL server it’s connected to for the source date, inc select getdate()).
The CMC Preferred Viewing Locale is set to UK and the time zone has been set to Default–Local to web server, Have I missed something in a universe based time / locale setting?

Thank you

yddraig (BOB member since 2008-05-13)

2

Unsure, but it could be related to this bug here?

https://bobj-board.org/t/214747

Mak 1 :uk: (BOB member since 2005-01-06)

3

Don’t think so, we went straight in at 4.1 SP5 Patch 4

It’s not a major issue currently as the users work by date and not time but I hate to see a loose end… especially one that may return later on and bite me…

Saying that, the post still seems to imply that SAP are still to resolve it…

yddraig (BOB member since 2008-05-13)

4

Ah OK.

I have my Current time zone set to GMT, have you tried that?

Mak 1 :uk: (BOB member since 2005-01-06)