Date Format changed after reading the excel

Date format is changing after converting the excel into datatable.
In excel dates are in ‘dd/MM/yyyy’ format. But after reading the excel, it is coming as ‘MM/dd/yyyy’ format automatically (while accessing the dt).
How do I get the date as it is in Excel.
Note: I have tried with preserve format property, but data gets changed with that.


If it is always changing then you can try as below


Hope this helps


1 Like