Skip to main content

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. 

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' )

 

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' )

 


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! 

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

Terms & ConditionsAccessibility statement