Hi, I was wondering what is the best way to deal with timezones? I noticed this comment: https://community.thinkwisesoftware.com/ideas-18/translating-domain-elements-556?postid=1643#post1643
As an ISV our customers are in different timezones. We currently deploy the application via Azure where we use 'UTC' time. But that isn't the locale time of the user / customer.
We currently only use time for 'inserted on' and 'modified on' and 'print date' for reports. The times the user sees should not be UTC, but its local time. I was thinking about storing the offset/timezone (sys.time_zone_info) in the customer database and use a helper function to display the local time (bit like https://community.thinkwisesoftware.com/development-13/is-there-an-easy-way-to-let-the-sf-handle-timezones-for-one-server-1124). For now that should be sufficient expecting all customer employees being in the same timezone.
Input wise we currently don't have any case of saving time-information, but I was wondering if anyone has experience with that? E.g. displaying locale time, but saving utc0 time.