Hi community,
I made an automation and the date is not the same/ Format in the table European. Should I make something special to avoid this ? Or did I miss something ?
Thank you !
Answer
Bug or mistake wrong date in my email
Best answer by JonathanBowen
Hi @NEPCO - Airtable holds the date in the standard ISO format (I assume) and what you are seeing the in the table is just a “front-end” format of this underlying date. The automation doesn’t use the table format so if you want a specific format in your email, make another field using a formula to make a “date as string” field:
with formula:
DATETIME_FORMAT(Date, 'DD/MM/YYYY')
Use this string date in the email and you’ll get the format you want:
+18Hi @NEPCO - Airtable holds the date in the standard ISO format (I assume) and what you are seeing the in the table is just a “front-end” format of this underlying date. The automation doesn’t use the table format so if you want a specific format in your email, make another field using a formula to make a “date as string” field:
with formula:
DATETIME_FORMAT(Date, 'DD/MM/YYYY')
Use this string date in the email and you’ll get the format you want:
Hi @NEPCO - Airtable holds the date in the standard ISO format (I assume) and what you are seeing the in the table is just a “front-end” format of this underlying date. The automation doesn’t use the table format so if you want a specific format in your email, make another field using a formula to make a “date as string” field:
with formula:
DATETIME_FORMAT(Date, 'DD/MM/YYYY')
Use this string date in the email and you’ll get the format you want:
Thank you soooooo much. :slightly_smiling_face:
Login to the community
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.