Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Remove UTC from Email Automation

Topic Labels: Automations
421 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Robert_William1
6 - Interface Innovator
6 - Interface Innovator

I have a sweet automation set up for a client that lists important dates in a grid format. The date includes "UTC" and I can't figure out how to get rid of UTC. As you can imagine with all employees in the same time zone, the addition of UTC is not only unnecessary, but unattractive. I appreciate any ideas you might have to remove this from the email auto. 

3 Replies 3

Try adding a formula field that outputs the format you want in the email and then using that instead:

Screenshot 2025-01-21 at 9.52.25 AM.png

 

DATETIME_FORMAT(
  Date,
  'MM/DD/YYYY'
)

 

Thanks for the reply. In this scenario, I need the email to show team members work anniversary. But instead of showing the year they started, I need the current date to display. I can't use "Today's date" because the email sends out anniversary date for the week ahead. Here was the formula I was previously using. 

 

DATETIME_PARSE(
DATETIME_FORMAT(
Anniversary,
"DD/MM"
) &
"/" &
YEAR(NOW()),
"DD/MM/YYYY"
)

Even though I'm pulling the info you suggested, it still shows up UTC in email format. 

Thanks again! 

Yeap, that's because your formula's outputting a date value, not a text value.  Try wrapping your formula inside another 'DATETIME_FORMAT' so that it outputs it as text