Skip to main content
Solved

Importing and Reformatting Date & Time

  • March 9, 2020
  • 2 replies
  • 72 views
N

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!

Best answer by neko_flow

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.

    2 replies

    kuovonne
    Forum|alt.badge.img+29
    • kuovonne
    • Brainy
    • March 9, 2020

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

    J
    N
    • neko_flow
    • Author
    • New Participant
    • Answer
    • March 10, 2020

    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.

    J
    Terms & ConditionsAccessibility statement