Date values do not get proper parenthesis when appending data

[Ries Spruit]

Hello,

I am trying to append data to a table on a 5.5.28 MySQL server.

There is a timestamp and a date column in the table. I have two date column in Excel. The Append Data wizard recognises these columns as such and also recognises the columns in Excel als DateTime columns.

Unfortunately, the query that is generated upon execution contains a syntax error:

INSERT INTO `table` (`TimeStamp`,`Date`) VALUES ('2016-01-31 22:19:57',2016-01-01 00:00:00)

Strangely enough, the value that is going into the timestamp column is parenthesized correctly. The date value however does NOT get any parenthesis. This results in a syntax error.

I trust this may have something to do with my locale (nl-NL, Dutch). Our date format is dd-MM-yyyy, which often gives issues. However in this case the format is not the issue, but the missing parenthesis is.

Any advice is appreciated.