Error When converting Month name to number

Help Studio
, ,
1

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.”

image
image1385×805 61 KB

2

@atarantino
Edited: rerunning the cross check

grafik

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

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

TrimDate
3

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

4

did update the post above
grafik
And also:
grafik

5

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