Hello Isabelle.

I am sorry to disappoint you, but unfortunately adding more than one date to a date column is not possible.

If you change it to string, it will not loose the data, but it will change the date format from what you set it to be in wpDataTables settings, to PHPMyAdmin (database) default format:

2019-06-25

Best regards.

Hi again Isabelle.

Can you, please share the URL to the table with me, so I can take a look?

Best regards.

Hello again Isabelle.

I see what you mean - when I double click on a date column, it comes up with a date picker, and adds it as 02/07/2019, correct?

I believe this is coming from the Editor input type. 

Please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

Best regards.

Hi again Isabelle.

I opened table #48, and saw that you did convert it to string, but the Editor input type remained as "Date", so that's why you're getting the date picker, and the dates are being displayed in the 01/01/2000 format. To make the table save it in the database's format 2000-01-01 you would need to enable the "One line edit", but in that case, users would be able to enter anything in the cells.

If you wish to keep the date picker, and keep this format, with the column's type still being string, you would need to change the date format in main settings of wpDataTables.

I hope this helps.

Best regards.

Hello Isabelle.

I'm glad to hear it's all sorted out.

I don't quite understand what you mean by displaying it as code. I logged into table #48 again, but couldn't recreate the issue.

Can you show me what you mean?

Best regards.

Ah, I see Isabelle.

Can you please tell me which version of libxml do you use?

You should find the libxml version in your php.info file.

If the version is less then 2.7.8

In file  wp-content/plugins/wpdatatables/source/class.wdttools.php and around line 896 I found this code 

if (self::isHtml($string)) {
$string = self::stripJsAttributes($string);
}

and comment it so the code look like this 

//if (self::isHtml($string)) {
//$string = self::stripJsAttributes($string);
//}

It should work then for your version of libxml.

You would, however, need to edit each cell and remove the < > brackets manually.

Best regards.