Help

Bug or mistake wrong date in my email

Topic Labels: Automations
Solved
Jump to Solution
1119 2
cancel
Showing results for 
Search instead for 
Did you mean: 
NEPCO
5 - Automation Enthusiast
5 - Automation Enthusiast

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 !
image

1 Solution

Accepted Solutions
JonathanBowen
13 - Mars
13 - Mars

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:

Screenshot 2021-04-23 at 22.10.55

with formula:

DATETIME_FORMAT(Date, 'DD/MM/YYYY')

Use this string date in the email and you’ll get the format you want:

Screenshot 2021-04-23 at 22.11.57

See Solution in Thread

2 Replies 2
JonathanBowen
13 - Mars
13 - Mars

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:

Screenshot 2021-04-23 at 22.10.55

with formula:

DATETIME_FORMAT(Date, 'DD/MM/YYYY')

Use this string date in the email and you’ll get the format you want:

Screenshot 2021-04-23 at 22.11.57

Thank you soooooo much. :slightly_smiling_face: