Error(Assign: The string ‘MM-dd-yyyy’ was not recognized as a valid DateTime. There is an unknown word starting at index ‘0’). There is no extra character before or after the date. But still not able to parse when trying to get from Excel.

Thank you Sir, The FirstAid tutorial helped me fix the error.

[image] ambulance sos [FirstAid] Datatable: Debug & Analysis invalid DateTime Strings / String to DateTime Parsing Issues Tutorials This FirstAid Tutorial will describe how DateTime parsing issues can be analyzed and handled. Click spoiler text when in a hurry:…

Hi @Raghuveer_M Could you try with the below one. The value in the excel is in ‘MM-dd-yyyy’ this format but in string datatype. Use the below expression in assign activity and initialize it in a datetime datatype variable. - Assign -> DateTime = DateTime.ParseExact(strStartDate,“MM-dd-yyyy”,Syste…

@Raghuveer_M Looks like you string is not a date but a dateformat…like MM-dd-yyyy …please check the same Cheers

Use Log Message to see the actual value you’re trying to parse. Post it here. Are you using Parse or ParseExact? Give us more info, details, show your code, etc so we can actually help.

HOW TO FIX BELOW ERROR

Help Activities

ppr (Peter Preuss) August 3, 2023, 5:57pm 2

Topic		Replies	Views
Datetime convert error Activities database , activities , question	5	555	September 6, 2023
Change Format DateTime Studio studio , question , variables_management	10	1129	February 23, 2024
Assign: String was not recognized as a valid DateTime while trying to convert string to datetime data type Studio studio , question , activities_panel	5	762	March 28, 2024
Error message: Assign: String was not recognized as a valid DateTime Studio studio , question , activities_panel	10	1231	April 4, 2023
Error when Converting String to Date format in data table Studio studio , question , activities_panel	3	585	June 10, 2023

HOW TO FIX BELOW ERROR

Related topics