How do I show date col. in date format?

How do I show date col. in date format?

AkritiAkriti Posts: 1Questions: 1Answers: 0

In my datatable I have a column with date format (ex. "15/05/2020") but when export to excel the format date is General.
Is there a way to explicitly tell datatables, when exporting data, make sure Date column is formatted as a date in the xlsx document?
The example here as the same problem. The format of the date cells is general not date.

https://datatables.net/extensions/buttons/examples/html5/simple.html

Answers

  • allanallan Posts: 54,523Questions: 1Answers: 8,525 Site admin

    At the moment, our Excel export only supports ISO8601 format as a "proper" date / time - e.g. 2020-05-15 would be exported as a date.

    If you are interested this is the part of the code in question. Potentially other formats could be added there if you needed to.

    Allan

Sign In or Register to comment.