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.
+31Try adding a formula field that outputs the format you want in the email and then using that instead:
DATETIME_FORMAT(
Date,
'MM/DD/YYYY'
)
+9Try 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.
Even though I'm pulling the info you suggested, it still shows up UTC in email format.
Thanks again!
+31Thanks 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.
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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.