Skip to main content

Date displayed by automation

  • April 28, 2022
  • 1 reply
  • 209 views
S

I’m using Airtable to schedule work orders for maintenance. I have an automation set up that selects information from a record including the date and time and emails it to those who need to be made aware.
The way the date and time is displayed in the automation email is not friendly for other users, is there a way to change this?

1 reply

J
  • John_Reid
  • Participating Frequently
  • April 28, 2022

Hey, a quick way to do this would be to create a formula field and use that formula field in your email automation.

The DATETIME_FORMAT function will let you format your date to a ‘friendlier’ version. See the example below

DATETIME_FORMAT({Date},'dddd Do MMMM.',"")

This changed the date to look like ‘Monday 10th October.’

You can find Airtable’s Format specifiers here to allow you to format your date how you would like.

Terms & ConditionsAccessibility statement