Error When converting Month name to number

I had a thread on here before and someone solved the code error for converting the month name to a number but I had to make some changes in my process (i was originally getting the date via a substring but realized that won’t work since each month is a different character length so now i use a regex to get it) and now the expression is throwing an error that the DateTime is not valid. Please see below. Any thoughts?

TrimDate is the date i am pulling off of my PDF and the assign highlighted is the code I am using to convert from April to 04. It has worked in the past but now is throwing the error “Assign: String was not recognized as a valid DateTime.”

Edited: rerunning the cross check


when looking to the screenshot we are missing the clossing " so far:

just for curious reasons can you try e.g. within the immediate panel:

DateTime.ParseExact(TrimDate.Trim(), "MMMM dd, yyyy", System.Globalization.CultureInfo.InvariantCulture)

And also


So if I do that, what happens next month for May?

did update the post above
And also:

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.