Script to POST a file

[hcadsktc]

Hello! I have set up an automation that post events that are scheudled on the days they happen. The automation is working well except for the time always posting in UTC despite the data being formated for EDT across all users for this particular table. I have added photos of the date set up in the table, the automation, and the post. Would anyone have advice on how to have it post in the correct timezone? Thank you!

[TheTimeSavingCo]

Ah...yeah, I think you're going to need to create a formula field that'll output the date in the format you want using DATETIME_FORMAT and possibly SET_TIMEZONE, and then use that formula field in your email I'm afraid