hello i have complex string manipulation to get element from website as part of scrapping and turn it into nice looking date string, the problem i wanna convert it to date so when i export it to excel it would be read as date not string. here’s my assign and manipulation of the string flight_date.…

If you need the current year automatically appended, Today should still work in year 2021. Do you always need it to be a certain year, for example, 2020? I am sorry, I am not sure I understand what is the question or problem.

Try setting the Data type of the data column in the DataTable to Date. And write that DataTable to Excel. That may be one way to go. Or, use Write Cell Excel Activity and instead of writing a value, write a formula to it that converts string form of Date to “Date”. Here is how this might work (Col…

but how do i convert a string with that format dd-mm-yyyy to an actual date variable in uipath because so far i have tried every method and it doesn’t work always give exception invalid date

Try out this manipulation - date.ParseExact(inputVariable,“dd-MM-yyyy”, system.Globalization.CultureInfo.InvariantCulture)

already did that and didn’t work

@Mohammad_Raafat please tell us the string that you used for parsing or share a screenshot from your used code

I don’t understand what you need to parse. Please be clearer with your question. Could you show us some sample input that you want to parse?

when i get text in a scrapping process the day and date is extracted like highlighted in screen shot. but then i clear the weekday / trim it / remove th st nd rd behind day. and i switch it to another valid date format as string but it is still a string not a date so i cannot compare it to another…

@Mohammad_Raafat if we got your right then Sat 17th Oct will look after your cleansing like 17-10-2020 right? so parsing should work as following [grafik] ensure following for this: [grafik]

Might I suggest a slightly more elegant way to do the same manipulation? DateTime.ParseExact(flightDate.Substring(4).Replace("th","").Replace("st","").Replace("nd","") + " " + Today.ToString("yyyy") ,"dd MMM yyyy", System.Globalization.CultureInfo.InvariantCulture)

String data manipulation to date

Help Studio

Mohammad_Raafat (Mohammad Raafat) October 20, 2020, 8:25am 13

The ParseExact did work, however it gave errors on some various dates
but i solved that by separating the date into variables and parse them as date with correct format

Topic		Replies	Views
How to convert string to dd-mmm-yyyy Help	10	7065	July 19, 2019
Help required to change date format Studio studiox , question	10	3007	March 6, 2021
Date conversion issue Help datatable , excel , uiautomation , studio	2	1984	September 2, 2018
Create date from day, month & year Studio activities , question	7	2445	June 23, 2020
How to convert a string to date Studio datatable , excel , orchestrator , studio , question , activities_panel	13	1655	December 12, 2022

String data manipulation to date

Related topics