datetime.ParseExact(OutputTextSQL,“MM/dd/yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“MMMM yyyy”) i read date from sql and want to use select date dynamically, and im put date from sql to output datatable string, so when im convert to datetime still erorr. please help me str…

Hi, How about the following expression? datetime.ParseExact(System.Text.RegularExpressions.Regex.Match(OutputTextSQL,"\b\d{2}/\d{2}/\d{4}\b").Value,"MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("MMMM yyyy") Regards,

Assign: String 'Date 11/06/2022 00:00:00 ' was not recognized as a valid DateTime

Help Community

hanungrizqi (Hanung Rizqi) November 15, 2022, 2:32am 5

Got it, Thanks you Yoichi.

1 Like

Topic		Replies	Views
ParseExact method throwing error Studio studio , question , workflow_diff	19	1277	April 13, 2023
String was not recognized as a valid DateTime error even after using DateTime.ParseExact Activities excel , variable	10	5125	March 17, 2022
String '1/2/2024' was not recognized as a valid DateTime Activities question , system	3	185	March 21, 2024
String not recognized as valid date time Studio studio , question	12	1146	February 7, 2023
Assign - String was not recognized as a valid DateTime Activities excel , activities , studio , question	8	3865	June 27, 2022

Assign: String 'Date 11/06/2022 00:00:00 ' was not recognized as a valid DateTime

Related topics