Transaction group, UTC tstamp when the Gateway is EST

[pturmel]

In the designer? You don't. (Everything in the designer uses the designer's time zone, pretty much.)

Clients will use the project timezone setting to translate timestamps naïvely displayed there (depending on the component, in Perspective).

Beyond that, you would be responsible for rendering timstamps to strings with forced time zone conversions. See this Perspective topic for techniques:

Ignition Perspective Page to show the client System date and time

Sure. I recommend DateTimeFormatter.ofPattern(). But I would move the complexity to a project script module with a DateTimeFormatter instance with your preferred pattern saved as a top level variable. Like so, perhaps: from java.time import ZoneId from java.time.format import DateTimeFormatter defaultFormatter = DateTimeFormatter.ofPattern("YYYY-MM-dd HH:mm") def zonedFormat(ts, zoneid, format=None): formatter = defaultFormatter if format is None else DateTimeFormatter.ofPattern(format) r…

Of course, if your transaction groups are storing into tables whose t_stamp columns are discarding timezone information, you may be screwed.