Assign activities: dateString = row.item(“Date”).ToString dateStringconverted = DateTime.ParseExact(dateString,“dd/MM/yyyy”,system.Globalization.CultureInfo.InvariantCulture) resulted in error :RemoteException wrapping System.FormatException: String was not recognized as a valid DateTime. at Sys…

@Shawn11 This format that you give in parseexact should exactly match with the input format you are providing… So this needs to be correct - dd/MM/yyyy And if you are reading data from excel generally display value and backend value might be different…to know the exact format check the data in da…

Error when Converting String to Date format in data table

Help Studio

ppr (Peter Preuss) June 9, 2023, 10:32am 3

Topic		Replies	Views
Date showing in excel and in the data table are different and needs conversion Activities datatable , uiautomation , activities , error	5	1763	March 24, 2021
How to convert a string to date Studio datatable , excel , orchestrator , studio , question , activities_panel	14	1600	December 15, 2022
String was not recognised as a valid time error in Build Data table Academy Feedback	29	2531	August 7, 2020
Assign: String was not recognized as a valid DateTime while trying to convert string to datetime data type Studio studio , question , activities_panel	6	622	March 31, 2024
Error message: Assign: String was not recognized as a valid DateTime Studio studio , question , activities_panel	10	1138	April 4, 2023

Error when Converting String to Date format in data table

Related topics