I have a "Date" field on a table that reads from a Google Spreadsheet. The column on the Google spreadsheet is formatted as date using the mm/dd/year format. The column of the WPDataTables plugin automatically detected the date column and configured the equivalent in the table. However, some ramdom entries do get the days with the months exchanged showing as dd/mm/year.

I have changed the properties of the table several times but it continues to do the same thing. Some entries show correctly and some don't. All entries are showing correctly on the Google Spreadsheet. 

Any ideas why I can't get the entries to show the proper format? Thanks