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
Convert.ToDateTime(row(“ColumnName”)).ToString(“dd/MM/yyyy”)
Hope this helps
Thanks
1 Like