Hi Everyone, I want to convert dates in general format to Date Time format in Excel. How can I do this? I read Excel with Read Range and converted it to Datatable. Later, when I convert to String and ConvertToDateTime, I get the following error. [image] [image]

Try this DateTime.ParseExact(date_time,"dd.MM.yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("MM/dd/yyyy")

Check these threads: https://forum.uipath.com/t/how-to-convert-string-to-date-time-uipath/472923 [image] All about Datetime - UiPath Tutorials Hi All, My recent post on datatable [All About Datatable- UiPath] ( https://forum.uipath.com/t/all-about-datatable-ui…

Hi @nilesay You try to convert the Date YourString → 22/09/2022 DateTime.ParseExact(YourString,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("MM/dd/yyyy") Output → 09/22/2022 Regards Gokul

Hi @nilesay You can try with this expression You need check what format did the datetime variable returning by DateTimevar.Tostring and the convert them with this expression DateTime.ParseExact("DateTimeVar.ToString",{"MM/dd/yyyy hh:mm:ss","dd/MM/yyyy hh:mm:ss"},System.Globalization.CultureInfo.I…

[image] Sudharsan_Ka: In the expression inside {} you can give whatever format but the format which it is returning in the previous step when you checked is the must format because it going to use that format and then it will convert to another format which you will give When I substitute thi…

@nilesay son_date must be a string variable Regards Sudharsan

You need to convert the string to Date Time? If yes try this CDate(date_time) or Convert.ToDateTime(date_time) Regards Sudharsan

Hi @nilesay How about this expression? CDate(DateTime.ParseExact(date_time,"dd/MM/yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("MM/dd/yyyy")) Regards Gokul

Hi @Sudharsan_Ka , I get the following error when I make ‘son_date’ variable String. [image]

[image] Sudharsan_Ka: CDate(date_time) or Convert.ToDateTime(date_time) Try this @nilesay

Hi @Gokul001 , when I make ‘son_date’ variable DateTime still this error “Assign: String was not recognized as a valid DateTime.” and when ‘son_date’ variable type is String I get the following error. [Screenshot (50)]

Convert to Date Time From String

Help Something Else

marian.platonov (Marian Platonov) September 21, 2022, 7:09am 2

Check these threads:

https://forum.uipath.com/t/how-to-convert-string-to-date-time-uipath/472923

Topic		Replies	Views
How to convert a string to date Studio datatable , excel , orchestrator , studio , question , activities_panel	13	1737	December 12, 2022
Convert string to date time Help	26	87212	June 10, 2022
Convert datatable string to datetime StudioX studiox , question	6	963	February 9, 2024
Convert string to DateTime not working Studio excel , studio , question , date , datetime	7	3612	June 8, 2022
String was not recognized as a valid DateTime Conversion problem Studio datatable , excel , robot , studio , question , variables_management	2	2424	January 5, 2022

Convert to Date Time From String

Related topics