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.

@jaydeepbhunia

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