Date Format in Excel Reading Activity

[Sarath (Sarath S A)]

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”

[loginerror (Maciej Kuzmicz)]

Hi @Sarath

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

Guidance on String/DateTime Conversion and String Manipulation

I’ve spent a huge number of hours over the past few days trying to get to grips with the unimaginable complexity of DateTime conversion from strings and understanding string operators for a really simple application - but failed! The generic Dot Net Web site is unhelpfully technical, full of jargon that, to a non-programmer, is unintelligible, and not specific to UiPath. The UiPath reference guidance is woefully inadequate. It’s clear to me that a comprehensive UiPath reference document is need…

[Sarath (Sarath S A)]

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.

[qt1211 (QT)]

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

[Vivek_Arunagiri]

Please check this link.

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