Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Importing and Reformatting Date & Time

Topic Labels: Dates & Timezones
Solved
Jump to Solution
3460 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.