
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 20, 2025 05:47 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 20, 2025 05:52 PM
Try adding a formula field that outputs the format you want in the email and then using that instead:
 
DATETIME_FORMAT(
Date,
'MM/DD/YYYY'
)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 21, 2025 08:28 AM
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.
Even though I'm pulling the info you suggested, it still shows up UTC in email format.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 21, 2025 08:44 PM
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
