Converting records from text to date

This could be done with the help of a formula field. The first step is to extract the date, which can be done with a regular expression (I can’t see the full name of your field, so I’ll just use “Original Date” for these examples):

IF({Original Date}, REGEX_EXTRACT({Original Date}, "[^\\s]*"))

That will extract everything up to—but not including—the first space, which falls after the date. With that string, you can then wrap a DATETIME_PARSE() function around the extraction:

IF({Original Date}, DATETIME_PARSE(REGEX_EXTRACT({Original Date}, "[^\\s]*")))

Airtable can natively parse several common date formats—including the YYYY-MM-DD version that the formula extracts—without specifying the format directly.

In fact, you might try directly parsing the entire string and see if it does the job without needing the extraction first:

IF({Original Date}, DATETIME_PARSE({Original Date}))

@Caitlin_Warlick-Shor - I was wondering if you could explain your solution further? I’ve been able to extract my date information using a formula, but can’t figure out how to turn the results of that formula into a date field type as you described in your original post. Any guidance would be appreciated!