So I have to take these date and time values from a csv file and I have to change them into “dd/MM/yyyy” format in order to be able to use it to compare values with another datatable. So for example: 4/5/2022 becomes 04/05/2022, and 18/2/2022 becomes 18/02/2022 and 7/11/2022 becomes 07/11/2022. …

[image] beepboop: ble to use it to compare values with another d hey @beepboop Are you sure if the date is as in the above format ? Thanks #nK

I suppose so? This was just a hacky way of quickly testing if they would work, but yes, the format is consistently as you can see in the default values. Here’s some more example: [image] I just noticed that in the excel preview it shows with AM/PM, so I tested out with values just from the table i…

Message Box: String was not recognized as a valid DateTime

Help Activities

ppr (Peter Preuss) May 16, 2022, 9:48am 4

[FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues - News / Tutorials - UiPath Community Forum

Topic		Replies	Views
Datetime convert error Activities database , activities , question	5	541	September 6, 2023
String was not recognized as a valid DateTime - Why this error is coming suddenly? Activities excel , activities , question	13	1375	December 1, 2023
String is not recognized as a valid datetime - MM/dd/yyyy format is only working Studio activities , studio , question , date , datetime	8	12401	April 18, 2022
Error: String was not recognized as a valid DateTime : Issue in getting the correct Format Studio excel , activities , studio , datetime-linq	4	5094	March 24, 2022
Me sale el error String was not recognized as a valid DateTime Studio uiautomation	5	577	February 13, 2023

Message Box: String was not recognized as a valid DateTime

Related topics