String gets converted to date format when saved in csv format

mayurmp

Hi all, I am having a value 10-02 which gets converted to 2-Oct or else if value is 12-86 then it gets converted to Dec-86 when saving in CSV format.

Regards,
Mayur

mayurmp

Please find the script used for the same,

$(document).ready(function () { $('#TableList').DataTable({ dom: 'T<"clear">lfrtip', "oTableTools": { "aButtons": [ "print", { "sExtends": "collection", "sButtonText": "Save", "aButtons": [ { "sExtends": "csv", "sCharSet": "utf16le" }, { "sExtends": "pdf", "sPdfSize": "A3", "sPdfOrientation": "landscape" } ] } ] } }); });

allan

I would suggest you use Buttons rather than TableTools as the later has been retried.

If you are still having this issue with the latest version of Buttons, please link to a test page showing the issue.

Allan

mayurmp

Thanks a lot Allan, I will sure check with the same and will update