Automation email with semantic date

[Kristen_Tcherne]

I have an automated email set up, using Gmail, for informing someone when their video is scheduled to be published. This is trigged once the publish date date field is set. I have changed the publish date date format from ISO to friendly format, but it still publishes the scheduled date as ISO format in the automated email.

Does anyone know how I generate an automatic email with the friendly date format?

Thank you!

[ScottWorld · Accepted solution]

You’ll have to create a formula field using the DATETIME_FORMAT function (and possibly the SET_TIMEZONE function), and then use that formula field in your email.

[Kristen_Tcherne]

A quick and easy fix - thank you!

[ScottWorld]

You’re welcome! Glad I could help! :slightly_smiling_face: