Date format formula

[rmm]

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

[Justin_Barrett]

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

[rmm]

@Justin_Barrett Simply change how it’s displayed.

[Justin_Barrett]

@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"))

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:

Airtable Support

Formula field reference

Formulas may involve functions, numeric operations, logical operations, and text operations that operate on fields. For an overview of formula fields, please refer to the Guide to Formula, Lookup, ...

[rmm]

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