Importing and Reformatting Date & Time

[neko_flow]

Hello there!

I have a lot of text-rows with following time-layout: Feb 15, 2020 8:22 AM. I can’t get it to import to my airtable styled rows: 15/2/2020 8:54.

Does anyone know what I can do?

Thanks!

[kuovonne]

Do the text rows already exist in Airtable, or are you importing from a file?

If you are importing from a plain text or csv file, the comma in the date could be messing up the import.

If the rows are already in Airtable as single line text, you could use a formula field with the DATETIME_PARSE() formula to turn the text into a date.

Then you can copy the result to a date field. Or, after parsing it, you could display it with the DATETIME_FORMAT() formula.

The details for the formula are in the formula field reference.

(Eventually a script will be able to do this, but I don’t know if one has been written yet.)

[neko_flow · Accepted solution]

Hey @kuovonne, thanks for the reply!

DATETIME_PARSE({Date}) fixed it on its own! Fantastic.