Skip to main content

I have an automation that sends an automatic email. There are 2 date fields in the text. This should display the date and time. unfortunately the date fields are displayed as in the attachment. how can I change this?

It would look nicer if everything was like the last one. could be removed

Hey @user2100!

Please find the solution to your issue in this related discussion (courtesy of @ScottWorld 😁).

I hope that helps!

Mike, Consultant @ Automatic Nation


Try creating a formula field and using DATETIME_FORMAT() to format them the way you want to see in your email, and then use them in your email automation

Here's a link to all the modifiers: https://support.airtable.com/hc/en-us/articles/216141218


Try creating a formula field and using DATETIME_FORMAT() to format them the way you want to see in your email, and then use them in your email automation

Here's a link to all the modifiers: https://support.airtable.com/hc/en-us/articles/216141218


I have created a formula field and the date and time are displayed in it. But if I use this formula field in an email text, the space remains empty.

The date formatting is correct in the table, but the formatting is displayed differently in the email text.


@user2100 I forgot to paste the corresponding link in my answer above. Please try the solution found here.


I have created a formula field and the date and time are displayed in it. But if I use this formula field in an email text, the space remains empty.

The date formatting is correct in the table, but the formatting is displayed differently in the email text.


Sounds like you haven't refreshed the data for your automation testing.  Try testing your trigger again


Reply