Time Converts to UTC in Email Automations

[Joel_Andrews1]

Whenever I include Date & Time fields in email automations, the time gets converted to UTC. Is there a way to prevent this?

Thanks!

[tygerl]

Hi Scott, 

I tried your 2nd suggestion to "create formula fields that you reference in your automation" and the automation is still translating in weird ways. 

Here's the formula in the reference field: 

DATETIME_FORMAT(SET_LOCALE({Event start time}), "dddd, MMMM DD, YYYY - h:mm:ss")

The reference field ends up looking like this, which is great: Wednesday, February 22, 2023 - 11:30:00

But is then translated to this in the automated email: 

2023-02-22T16:30:00.000Z

Any help is much appreciated!

Lauren