TableExport
TableExport copied to clipboard
xlsx doesn't support dd/mm/yyyy date format as source data
trafficstars
Hello, my source table has field with dd/mm/yyyy as date format and when exporting to xlsx the datatype of the filed is "string" and not "date" (this means problem when sorting that column). If I use mm/dd/yyyy in my field the datatype is correctly recognized as "date" but not when the source field has dd/mm/yyyy content. I would expect that the date format dd/mm/yyyy is recognized as a correct date as is. Version 5.2.0
As today, the only plugin which support dates in dd/mm/yyyy is the hhurz/tableExport.jquery.plugin