Copy date from Excel and Paste with uipath


#1

Hello guys! Good Afternoon!

I need your help…

I need copy date from Excel in format " dd / MM / yyyy ", but when uipath paste the date on my system, he paste in format " MM / dd / yyyy ".

How I can correct this?

Thanks!


#2

HI @arthurfs11,

Use assign activity

dt_faturamento=Convert.ToDateTime(dt_faturamento).ToString("dd/MM/yyyy")

Regards,
Arivu


#3

@arthurfs11

Convert.ToDateTime will work only if your for string format is like this MM/dd/yyyy or MM-dd-yyyy

Since your date format is dd/MM/yyyy
Try this
DateTime.ParseExact(string_date,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvarientCulture).ToString(“dd/MM/yyyy”)

Regards,
Mahesh