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