Query With Export Datetime in Excel

Ponmurugan

Link to test case:
Debugger code (debug.datatables.net):
Error messages shown:
Description of problem:

Ponmurugan

Hi I need help with Export Excel.. I want to Export Datetime in Excel. It can be Exported as Datetime in Excel But it was stored as text not in DateTime. Due to this issue Unable to Filter the Date Columns in Excel Sheet. So Anyone give me a solution??

I am trying to Export the Following Data in Excel

[
1,
"22/09/2022 16:47:25",
"22/09/2022 16:47:26",
"18/11/2022 06:35:00",
7774,
822,
9096,
500,
9096,
"Confirmed",
"",
"Aravind V"
]

rf1234

Use "customize" please. You'll find many posts on this in the forum.

https://datatables.net/reference/button/excelHtml5