Automated emails - remove unsubscribe link

[Robert_William1]

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. 

[TheTimeSavingCo]

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

[Robert_William1]

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! 

[TheTimeSavingCo]

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