DateTime Manipulation - String was not recognized as a valid DateTime

ppr · August 11, 2022, 7:35am

in addition to @supermanPunch also find following firstAid sheet introducing to this topic and also showing analysis techniques

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

Same as discussed by Arpan the multiple formats were handled with a format array

About the DateDiff function take a note that not fractions of the selected unit is returned. When this is needed / important let us know for presenting additional techniques

Topic		Replies	Views
Change Format DateTime Studio studio , question , variables_management	10	1070	February 23, 2024
Error message: Assign: String was not recognized as a valid DateTime Studio studio , question , activities_panel	10	1210	April 4, 2023
How to convert a string to date Studio datatable , excel , orchestrator , studio , question , activities_panel	13	1693	December 12, 2022
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
String was not recognized as a valid DateTime Conversion problem Studio datatable , excel , robot , studio , question , variables_management	2	2412	January 5, 2022

DateTime Manipulation - String was not recognized as a valid DateTime

Related topics