Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Automation email with semantic date

Topic Labels: Automations
Solved
Jump to Solution
628 3
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

1 Solution

Accepted Solutions

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.

See Solution in Thread

3 Replies 3

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.

A quick and easy fix - thank you!

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