DateFormat - Excel - Uipath

Help Studio
1

hello everyone,
i have the following problem:
I have an excel file that I read from uipath in which I have a date type column (Date of Extraction) in this format → dd/MM/yyyyy

The regional computer settings on windows are in Spanish dd/MM/yyyyy

My question is this:

Why is it that when I do read range from uipath it reads the date in this format MM/dd/yyyy?

Thanks in advance

2

its the system threading setting, I normally use an assign to get by this for my projects.

System.Threading.Thread.CurrentThread.CurrentCulture =
new System.Globalization.CultureInfo(“nb-NO”)

spain should be something like: es-ES

3

Hey!

The system DateTime format is “MM/dd/yyyy”

we can change it to any format like this

Datetime.ParseExact(Strinput.ToString, “MM-dd-yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dd/MM/yyyy”)

Try this and let me know…

Regards,
NaNi