Time offset 1 hour out when accessing datetimes with datetime set in GMT when in BST

[kale1d0code]

Issue

The CRM system uses UTC to store and process datetimes.
The system offsets any times it stores with an end-user timezone mostly for viewing purposes but this would happen anytime a datetime is accessed for any reason.

This causes problems when sending automated emails.
The system uses UTC when it sends emails outside of a user context which causes every single datetime used in an email template to be incorrect if the email wasn't sent due to an end-user action.

When a user views a GMT datetime when the actual date is BST, the viewed datetime would also be incorrect.

This issue affects all SuiteCRM versions I have used 7.10 -> 7.14

Possible Fix

implement a system timezone to offset datetimes during automation (outside user context)

do not mix BST and GMT

Steps to Reproduce the Issue

1. create a workflow or logic hook which extracts the time from a datetime to something like a text field for a record
2. set this datetime to a date in november on your record (GMT)
3. set your system time to a date or time within BST
4. trigger the workflow / logic hook
5. observe the incorrect time on the textfield
...

Context

sending out meeting notifications to delegates and the delegates showing up an hour early.

Version

7.14.2

What browser are you currently using?

Chrome

Browser Version

Google Chrome Version 129.0.6668.89 (Official Build) (64-bit)

Environment Information

MariaDB 10.9.4 | PHP 7.4.25

Operating System and Version

Debian GNU/Linux 10 (buster)