Date format formula

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

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

@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. :slight_smile:

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 . . .

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.