Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Bug or mistake wrong date in my email

Topic Labels: Automations
Solved
Jump to Solution
322 2
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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: