Date Format in Excel Reading Activity

Help
1

Hi All,

Note: [URGENT]

I am facing an issue with the Excel Read Range activity, When the activity is used it converts the excel date in mm/dd/yyyy format to mm/dd/yyyy

I think UiPath is using the default date culture “en-US”, is there a way to override the format to “en-GB”

2

Hi @Sarath

I hope you can find enough info to convert the value to the desired one over here:

1 Like
3

I am unable to convert any dates as i want the whole table;

if am to convert i need to convert separately as dates below 12th of the month and > 12th of the month.

My problem is the dates in excel is in format dd/mm/yyyy but when uipath reads it it converts it to mm/dd/yyyy for all the dates below 12th of the month.

since i believe it is using a en-US culture inside the read range activity.

1 Like
4

I’m having the same problem. Have you found a way to solve this? Thank you.

5

Please check this link.

https://forum.uipath.com/t/get-a-date-in-formart-dd-mm-yyyy/2440/9?u=vivek_nalashaa

7

These links aren’t much use to us. We’d need to do a for each row (often unwieldy) and reformat each cell.

8

You can use a for each row in datatable activity, and update the date format value with an assign activity