Help

Date format formula

Topic Labels: Formulas
1357 4
cancel
Showing results for 
Search instead for 
Did you mean: 
rmm
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there,

Can anyone please help me convert the date in this format,

Fri Jan 13 2017 00:00:00 GMT+0000 (Coordinated Universal Time)

to this 01/13/2017 format?

Thank you

4 Replies 4

Will you be running any calculations on this converted date, or do you want to simply change how it’s displayed?

rmm
5 - Automation Enthusiast
5 - Automation Enthusiast

@Justin_Barrett Simply change how it’s displayed.

@rmm I saw your first reply. No need to reply a second time. I’ve been busy over the weekend, and this is the first chance I’ve had to get back to this. :slightly_smiling_face:

In short, what you need to do is convert (parse) the existing date into a datetime—the data format that Airtable uses for recording date and time information—and then format the result as desired.

This should work:

IF(Original, DATETIME_FORMAT(DATETIME_PARSE(Original, "ddd MMM DD YYYY "), "MM/DD/YYYY"))

Screen Shot 2021-06-21 at 9.36.25 AM

As you can see, you don’t necessarily need to include every single piece of data from the original. In this case, we can get by with the core pieces needed to extract the date info.

More about Airtable’s date and time operations can be found here:

@Justin_Barrett Thank you. I did that because I wasn’t sure you would see it without the @ and your name. There was no hurry. Sorry . . .