Date displayed by automation

Topic Labels: Automations
1478 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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 1
5 - Automation Enthusiast
5 - Automation Enthusiast

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.