Date Copy Paste is broken


#1

I’m unable to copy & paste dates from anything into Airtable date column, be it a spreadsheet, notepadd++, or an HTML table.

Some dates paste & appear, but the day swaps with the month, and when the day is between 13 & 31 then the entire paste fails.

My local date format is;

dd/M/yyyy

But even when I change date settings on my OS, or switch up the date settings in Airtable, the paste into Airtable still breaks. If I change the Date column to Text column, then everything pastes OK, but as soon as I then change the column back to date, all the days & months flip and break again.

Sample data below;

27/08/2017
24/09/2017
11/09/2017
10/09/2017
05/09/2017
30/08/2017

Results in;

<BLANK>
<BLANK>
<BLANK>
9/11/2017
9/10/2017
9/05/2017
<BLANK>