String not recognized as a valid date

[Rakesh_Tiwari]

Hi All,

one of my process is suddenly started failing throwing below log error.

how to solve this issue

kindly help

[NIVED_NAMBIAR (NIVED N)]

Can u show the date and activity used to convert the string to date

Also did u retrived the date from excel? @Rakesh_Tiwari

[Rakesh_Tiwari]

it was working fine earlier, not now showing issue.

[NIVED_NAMBIAR (NIVED N)]

what is IO_dictNAVPOData(“NNE-ReqRecptDate”)
is it the queue item?

[Rakesh_Tiwari]

no, it is not a queue item.

it is a purchase order form which reads as a dictionary and this “ReqRecptDate” is one of the column in Dynamics application, which reads as string and put in excel purchase order form.

[NIVED_NAMBIAR (NIVED N)]

I think u need to provide the input date format to

datetime.parseexact()…

Regards
Nived N

Happy Automation

[Rakesh_Tiwari]

where do i need to change in code, can you help me with that?

it is in production so i am little nervous untill unless i am very sure.

[NIVED_NAMBIAR (NIVED N)]

I will give u an example

lets say date in format

d1 = 27/03/2020

u need to convert to dd.MM.yyyy

So do the following

d2 = DateTime.ParseExact(d1.ToString,“dd/MM/yyyy”,System.Globalization.InvariantCulture.Cultureinfo).ToString(“dd.MM.yyyy”)

where d2 is in string with date format of dd.MM.yyyy

Regards
Nived N
Happy Automation

[Rakesh_Tiwari]

This is assigned to

now you mean to say i need to change here
with your solution.
DateTime.ParseExact(d1.ToString,“dd/MM/yyyy”,System.Globalization.InvariantCulture.Cultureinfo).ToString(“dd.MM.yyyy”)
now what will be d1 in my case, is it cultDKCulture?

Also suppose it is 17/02/2021 it should come like 17-Feb-2021

[NIVED_NAMBIAR (NIVED N)]

Hi @Rakesh_Tiwari

U can try like this

DateTime.ParseExact(IO_dictNAVPOData(“NNE-ReqRecptDate”), “dd/MM/yyyy”,cultDKCulture).ToString(“dd-MMM-yyyy”)

Try this

Regards

Nived N
Happy Automation

[Rakesh_Tiwari]

like this you want me to try?

or only
DateTime.ParseExact(IO_dictNAVPOData(“NNE-ReqRecptDate”), “dd/MM/yyyy”,cultDKCulture).ToString(“dd-MMM-yyyy”)

[NIVED_NAMBIAR (NIVED N)]

Yes @Rakesh_Tiwar

[Rakesh_Tiwari]

ok, sure

[Rakesh_Tiwari]

why it is coming like that, when it is already declared?
scope is also correct, that is workflow

[Rakesh_Tiwari]

@NIVED_NAMBIAR , can you please see my error?

why it is coming.

[NIVED_NAMBIAR (NIVED N)]

U can u directly write the values in the code itself that value of cultDKCulture @Rakesh_Tiwari

[Rakesh_Tiwari]

[NIVED_NAMBIAR (NIVED N)]

instead of cultDKCulture can u try with this

System.Globalization.CultureInfo.InvariantCulture

@Rakesh_Tiwari

[Rakesh_Tiwari]

changed the variable to string, and then error gone, is it ok?

trying to run, then let you know,

also like to let yyou know i commented below activity
is it ok na?

[Rakesh_Tiwari]

now below code has got some error.

?