How to retain the date format when exported to excel

PhaneK24

{ match: /^[\d]{2}\/[\d]{2}\/[\d]{4}$/, style: 67, fmt: function (d) {return Math.round(25569 + (Date.parse(d.substring(4,8)+"-"+d.substring(2, 4)+"-"+d.substring(0, 2)) / (86400 * 1000)));}}//Date dd/mm/yyyy

I tried this and when i exported into excel the date format is not dd/mm/yyyy and its showing the dd-mm-yyyy .And the date format is coming based on the system time format .

Can anyone please tell me how to retain the date format when exported into excel ??like it should not change whatever the systems time format. when exported to excel it should be dd/mm/yyyy

Thanks in Advance.

colin

We're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

Cheers,

Colin

PhaneK24

Thanks @colin

But i cannot provide the test case right now.
Could you please help me how to achieve the same date format in html table in view and excel (dd/mm/yyyy)

i am open for suggestion and thanks in advance