Excel export change dates

jgcaudet

My code
[{extend: 'collection',
text: '<i class="far fa-file-excel fa-2x"></i>',
key: {key: 'x', altkey: true},
buttons: [
{
extend: 'excel',
text: 'Todos',
exportOptions: {columns: ':visible'},
extension : '.xlsx'
},
{
extend: 'excel',
text: 'Seleccionados',
exportOptions: {modifier: {selected: true}, columns: ':visible'},
extension : '.xlsx'
}
]
}] ;

If I have in a register in my database with a date field with this value '2023/09/20' it exports in my excel this date like '20/09/2023'
But if the register contains a date '2023/09/12' it exports in my excel this date like '09/12/2023' (change day by month when day is 12 or lower)
Can you help me ?

allan

Happy to take a look at a test case showing the issue. I'd also suggest you click on the cell in Excel - it can format dates to the locale, which is probably what is happening in the first instance.

Allan