Help

Importing and Reformatting Date & Time

Topic Labels: Dates & Timezones
Solved
Jump to Solution
2466 2
cancel
Showing results for 
Search instead for 
Did you mean: 
neko_flow
4 - Data Explorer
4 - Data Explorer

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!

1 Solution

Accepted Solutions

Hey @kuovonne, thanks for the reply!

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

See Solution in Thread

2 Replies 2

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.