When I use ExecuteSelectToExcel to create an Excel file, date field are exported in the XLS as a number.
Can this be changed somehow?
Hi Raymond Vermeer,
For date fields convert to text prior export.
Hope that it helps you
Looks like this is an open issue since long time and you can see a similar question in Review section of this component. Behind the scene this component is using EPPlus https://github.com/JanKallman/EPPlus/ and this issue are discussed in many places and solutions are given.eg: https://stackoverflow.com/questions/34137533/detect-datatable-date-field-and-force-date-format-in-epplus-export. if your bandwidth permit please see if you could implement this patch.