How to use a formula in an email (automation)

Hello All,

I am new to Airtable & have searched but could not find a solution to my query.

My table has the following fields (and a couple of more).

5 days before the due date, I send myself a reminder mail.
And, this seems to be fine (preview tells me it is fine).
The issue is the format of the due date.
I want the format to be 22-Jul-2022 but the email shows 2022-07-22
I used the formula in the email, but it is treated as text in the email.
I created another field (column) with my kind of format and the column shows the format, but when I reference this column in my email, the content is blank.

Can you please help me?


Hey @Vikas!
Welcome in!

So, one way to handle this is to create a formula field that formats your date value.
In this case, you’ll want to use the DATETIME_FORMAT function.

You can use this format as an example:

    {Date Field},

This will provide you a value in your desired format of: 22-Jul-2022.
You’ll use that formula field to plug into your email/automation, instead of your original date/time field.
If I remember correctly, this formula will produce a string data type, rather than a date data type.

This means that Airtable will not transform the data when it goes through an automation, which is what was causing your original issue.

The DATETIME_FORMAT function is my best friend.
If you want to play around with the formatting, here is a link to the formatting options.

Please let me know if something breaks, if I’m wrong, or if you have any additional questions!


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