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.

Date Format is automation is different than what appears in the table

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

I would like for dates in the Automation to appear as July 4, 2022, for example. Instead, they appear as 2022-07-04.

I have the date field formatted as ‘Friendly’. However, this does not appear to translate to the automation. I thought about creating another field that formats the friendly version of the date as text. But, that seems a bit cumbersome for each of my date fields.

Any workarounds that I’m not considering?

1 Solution

Accepted Solutions

Same idea as the answer here:

^ Use a Formula field with the DATETIME_FORMAT function to explicitly define the format of the field, use that Formula field instead of the original date field in your Automation.

See Solution in Thread

2 Replies 2

Same idea as the answer here:

^ Use a Formula field with the DATETIME_FORMAT function to explicitly define the format of the field, use that Formula field instead of the original date field in your Automation.

DATETIME_DIFF for the win.

Thank you!