String not recognized as valid date time

Help Studio
,
1

image
DateTime.ParseExact(dateOfBirth.ToString,“dd-MM-yyyy”,System.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy-MM-dd”)
Getting an error as cant convert date to string when i try to remove last to string value

2

@Arvind_Karthigayan

Code should be like this

DateTime.ParseExact(dateOfBirth.ToString,“yyyy-MM-dd”,System.Globalization.CultureInfo.InvariantCulture).ToString(“yyyy-MM-dd”)

Since format of date is yyyy-MM-dd

3

Hi,

Please store the output in a string variable instead DateTime variable.
This will resolve the error.

  • If Input format is “dd-MM-yyyy” then use below code.
Str_Var= DateTime.ParseExact(StringInput.ToString,"dd-MM-yyyy",System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy-MM-dd")
  • If Input format is “yyyy-MM-dd” then use below code.
Str_Var= DateTime.ParseExact(StringInput.ToString,"yyyy-MM-dd",System.Globalization.CultureInfo.InvariantCulture).ToString("yyyy-MM-dd")

Regard,
Ashutosh gupta

1 Like
4

How do i add str_Var not allowing me

5

You need to create a string variable str_var for that @Arvind_Karthigayan

6

image
image772×477 51.9 KB

Getting this

7

Try this @Arvind_Karthigayan

DateTime.ParseExact(dateOfBirth.ToString,{“dd-MM-yyyy","yyyy-MM-dd"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString(“yyyy-MM-dd”)

Regards
Sudharsan

8

And also i see in the screenshot that it should be in the format DD-MM-YYYY

So use this in type into @Arvind_Karthigayan

DateTime.ParseExact(dateOfBirth.ToString,{“dd-MM-yyyy","yyyy-MM-dd"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString(“dd-MM-yyyy”)

Regards
Sudharsan

9

Just remove "str_var = " from the Type this* box.

Cheers :smiley:

10

Yes ofc @Arvind_Karthigayan

You can just remove the str_var= in the value field and use the expression

str_var is just for your reference and its like variable there,

If you want to parse the date in multiple formats you can use the expression i sent and if you have any other formats you just need to add them in the array of formats in the expression

DateTime.ParseExact(dateOfBirth.ToString,{“dd-MM-yyyy","yyyy-MM-dd"},System.Globalization.CultureInfo.InvariantCulture,System.Globalization.DateTimeStyles.None).ToString(“dd-MM-yyyy”)

Regards
Sudharsan

11

image
image939×689 129 KB

Getting This error

13

And also can you check this @Arvind_Karthigayan

image
image442×550 81 KB

I see here there is no comma inbetween g and { if you not have that add the comma there

14

And the formats should be separated like this

{“dd-MM-yyyy”,“yyyy-MM-dd”} and not like this {“dd-MM-yyyy,yyyy-MM-dd”} @Arvind_Karthigayan