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”
I hope you can find enough info to convert the value to the desired one over here:
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.
I’m having the same problem. Have you found a way to solve this? Thank you.