Pasting in European dates via CSV


#1

I just imported a CSV into a new base.

I’m in England, so the system that generates my reports automatically uses the DD/MM/YYYY HH:MM format for dates.

When I imported the data, everything looked fine. At the time it was a text field.

I decided to change the field type to Date. Before any of the data was converted, I made sure to choose ‘European’ in the dropdown.

The problem is that upon clicking ‘Okay’, Airtable does not associate the choice of date format with the pre-existing data in the fields.

So what happens is that any dates before the 12th of a month are reversed (for example the 9th of December becomes the 12th of September), and any dates that occur after the 12th of the month are simply wiped as they’re not recognised as a date.

This leads to a table that looks more like this:

Is it possible for the Date field to take the date format choice into account before it decides how to parse this data?


#2

Hi Matt. A quick thought… Maybe you could format your source file date field in the American way, export to your Csv, import to airtable. Airtable should treat your field as a date and not a text so you finally can change it to European format.


#3

Hi Emilio, good idea. I’ll try it.

Definitely think this is a bug worth fixing, though.


#4

Hello,
I have excactly the same problem when importing cvs with local date format (Switzerland).
I have already notified the Airtable team on this behavior.
Hope it will be corrected soon


#5

This is the stupidest problem! So annoying!

Has anyone found a solution?


#6

Anyone find an answer/response to this date format issue?