Date conversion to specific format

[Rreddy]

Hi everyone, i got struck in date conversion.
I have a Excel and it have some dates and i need to look for today date in that but I’m unable to match it. Can anyone help me

Code which I’m using is :
DateTime.ParseExact(CurrentRow(0).ToString, “MM/dd/yyyy”,System.Globalization.CultureInfo.InvariantCulture)

But this is not working it is throwing error like string is not valid date time

Input:

[ABHIMANYU_THITE1 (ABHIMANYU THITE)]

Hi @Rreddy -

Try this

DateTime.ParseExact(CurrentRow(0).ToString(), "M/d/yyyy", System.Globalization.CultureInfo.InvariantCulture)

[Rreddy]

Hi @ABHIMANYU_THITE1 getting same error like string was not recognised as a valid date time

[ABHIMANYU_THITE1 (ABHIMANYU THITE)]

Hi @Rreddy - can log there what value you received in the CurrentRow(0).ToString()

[Rreddy]

@ABHIMANYU_THITE1

[Shiva_Nikhil]

@Rreddy

Can you try this way

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

[Rreddy]

Hi @Shiva_Nikhil

[ABHIMANYU_THITE1 (ABHIMANYU THITE)]

Hi @Rreddy

Use this -

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

[Rreddy]

Thanks @ABHIMANYU_THITE1 it’s working.