Hi Everyone.
I have trouble but do not know anyway to resolve. I have tried to find all of thread but still same.
The excel file has a column with Date format ( dd/MM/yyyy)… but it has problem when i read it to convert the format which i want.
I have tried to convert into many way such as :
- Convert.ToDateTime(row(“Date”).ToString)
- Datetime.ParseExact(row(“Ngày giao dịch”).ToString,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)
Before convert it into format i want, i have read it first and it show result as below picture. But it still error after i convert.
How to resolved this issue?
Thanks in advance!