Date formating using UIpath from Excel

[Chris_Balance]

Hello! I have in Excel column date formating “dd.mm.yyyy”, but I need output on UiPath “mm.dd.yyyy”. How to do that? At the moment I am using TypeInto activity for browser automation with inputText: releaseDate.Replace(“.”,“”)

releaseDate is String variable

I would love to connect with you through teamviewer since I am new to UiPath

[Suraj_B_Shetty (Suraj)]

Hi @Chris_Balance

Try this

releaseDate=DateTime.ParseExact("18.03.2023","dd.MM.yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("MM.dd.yyyy")

Hope this helps

[Chris_Balance]

@Suraj_B_Shetty

releaseDate=DateTime.ParseExact("18.03.2023","dd.MM.yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("MM.dd.yyyy")

I pasted this in type Into activity, but error shows up. Probably don’t know how to use your script then sorry

[Suraj_B_Shetty (Suraj)]

Hi @Chris_Balance
Try this

DateTime.ParseExact(releaseDate,"dd.MM.yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("MM.dd.yyyy")

[Chris_Balance]

Worked! Thank you