Problem with read excel

I have problem with read two excel file with datetime. One file read range and uipath display 27/07/2020 and another one read range and uipath display 07/27/2020 . What is different please help me

Hi @greentea_Teagreen :wave:

No issues. When you are using the date, use a common format by doing Convert.ToDateTime(row("Date").ToString).ToString("dd/MM/yyyy"). This way you can have a common format.

Cheers!