Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Sep 10, 2024 05:24 AM
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
Solved! Go to Solution.
Sep 10, 2024 05:50 AM
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
Sep 10, 2024 07:47 AM
Sounds like you haven't refreshed the data for your automation testing. Try testing your trigger again
Sep 10, 2024 05:40 AM - edited Sep 10, 2024 06:23 AM
Hey @user2100!
Please find the solution to your issue in this related discussion (courtesy of @ScottWorld 😁).
I hope that helps!
Mike, Consultant @ Automatic Nation
Sep 10, 2024 05:50 AM
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
Sep 10, 2024 06:14 AM
Sep 10, 2024 06:23 AM
Sep 10, 2024 07:47 AM
Sounds like you haven't refreshed the data for your automation testing. Try testing your trigger again