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;
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
<BLANK> <BLANK> <BLANK> 9/11/2017 9/10/2017 9/05/2017 <BLANK>