Skip to main content

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!

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

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


Hey @kuovonne, thanks for the reply!


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

Terms & Conditions