Uipath reads the data from excel in MM/dd/yyyy Format, but the value is in dd/MM/yyyy

[hansen_Lobo]

Hello Community,

I have trouble solving this issue.

I have a excel sheet with a column with dates which is in dd/MM/yyyy format.

But as soon as i read in UiPath it shows in MM/dd/yyyy format.

This is causing some serious troubles.

Can anyone help me with this?

[Shiva_Nikhil]

@hansen_Lobo

you can use format cell activity to change the date format in excel

or you can change the datatype using linq,if so provide a sample input

[hansen_Lobo]

can you suggest other way to do it? I don’t have excel in my system

[Parvathy (PS Parvathy)]

Hi @hansen_Lobo

While using Read Range Workbook enable Preserve Format option in the properties. It won’t change the format.

Regards

[hansen_Lobo]

Thank you, I hope this will work!!! will try and get back you you.