String was not recognized as valid Date Time

Learning & Development Programs Automation Starter
1

Hi Guys.

I am passing this ‘str_User_DepDate’(which holds the date read from excel) variable to another workflow, where the argument’s data type is ‘DateandTime’
and I have converted the string to date and time by using this ‘Convert.ToDateTime(str_User_DepDate)’ but I am getting this error stating;
“Invoke WebDataExtraction workflow: String ‘15/09/2022’ was not recognized as a valid DateTime.” Any idea on how to solve this?

Your help is much appreciated.

Regards
Chendoran

2

try this instead to convert your string to datetime

Datetime.parseExact(str_User_DepDate, "dd/MM/yyyy", nothing)

3

can you tell me bit are you trying to convert to other format?

DateTime.ParseExact(strIn, “dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture)

try this

4

Hi @Chendoran_M

Can you confirm that your passing str_User_DepDate from one workflow to another workflow correct?

If yes, What are the Variable and Argument type?

Regards
Gokul

5

The passing of the variable is correct. The variable is of type string and the argument is of type DateTime.

6

Change the Argument type to String and check it

Regards
Gokul

7

Hey!

Try this…

Datetime.ParseExact(Strinput.ToString, "MM/dd/yyyy", System.Globalization.CultureInfo.InvariantCulture).ToString("dd/MM/yyyy")

Regards,
NaNi

8

Didn’t work. Got this error again,
System.FormatException: String ‘22/03/2023’ was not recognized as a valid DateTime.

9

This has worked. Thank you @jack.chan

1 Like
10

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