Can you show us an example of dates? Try just pasting in about 10 rows of whatever you were trying to paste in your table. Then highlight it. Then in this forum comment text editor click on the “</>” (Preformatted text).
Firstly, you should be able to change the format at whim, while customizing the field. Secondly, customize the field to be a date field, before pasting any data.
Let me know if that helps.
Try moving that first record down a bit and see if it’s always the first record, or if it’s a coincidence and only that specific record.
If you want, you can make me an edit only user so I can troubleshoot. But it would take some trust. I don’t know ...