Facing issue while using this expression

[Shiva_Nikhil]

Hi

Before to the latest update it is used to work

Can anyone help me on how to resolve this error

DateTime.ParseExact(CurrentRow(2).ToString,{"MM/dd/yyyy hh:mm:ss", "MM/dd/yyyy HH:mm:ss"}, System.Globalization.CultureInfo.InvariantCulture).ToString("MM/dd/yyyy hh:mm:ss")

[ppr (Peter Preuss)]

the method signature, when using a string array with formats is

DateTime.ParseExact Method (System)

so we pass 4 Arguments

[mkankatala (Mahesh Kankatala)]

Hi @Shiva_Nikhil

I have modified your expression it will works now, check the below modified expression,

DateTime.ParseExact(CurrentRow(2).toString,{"MM/dd/yyyy hh:mm:ss", "MM/dd/yyyy HH:mm:ss"}, System.Globalization.CultureInfo.InvariantCulture, DatetimeStyles.None).ToString("MM/dd/yyyy hh:mm:ss")

I just added DatetimeStyles.None after the comma in the expression.

Hope it helps!!

[mkankatala (Mahesh Kankatala)]

I hope you find the solution for your query… @Shiva_Nikhil

If yes, Make my post mark as solution to close the loop. Else happy to help.

Happy Automation!!