Format Dates for Email Action

When inserting a Date field in an Email Action, the Date and Time format I’ve set within the table does not get used. Instead, I get the default formatting, something like: 2020-06-07T01:00:00.000Z. I’d like the date and time to be outputted in a more readable format in emails, something like 6/7/2020 at 1:00am.

Welcome to the community, @Jerry_Chan!

As you’ve discovered, the automations won’t pull the date formatting directly from the date field itself.

But there’s an easy fix, and this also gives you a lot more flexibility than what a date field can give you. :slight_smile:

Your solution is to simply create a formula field where you format the date in whatever way you’d like, using the DATETIME_FORMAT function.

So in your case, your formula would look like this:

DATETIME_FORMAT({Your Date Field},'M/D/YYYY \at h:mma')

The only tricky part here is that I had to put the backslash character before the letter “a” in the word “at”, because that “escapes” the character, meaning that it will output exactly as I typed it in.

Otherwise, without the backslash character, that “a” would have turned into “am” or “pm”. And that’s because the letter “a” is one of your formatting specifiers for the DATETIME_FORMAT function.

Once you build your formula, then you can just reference that formula field inside your email action, instead of referencing your original date field.

1 Like

Welcome to the Airtable community!

To add on to ScottWorld’s advice, the date/time will be in GMT time, unless you also set the timezone with the SET_TIMEZONE function.


DATETIME_FORMAT(SET_TIMEZONE({date/time field}, 'Australia/Sydney'), 'M/D/YYYY h:mm')

2 Likes

Thanks for the additional catch, @kuovonne!! :cowboy_hat_face: :raised_hands:

This topic was solved and automatically closed 3 days after the last reply. New replies are no longer allowed.