Convert the Date Format

[SP_Bot]

Hello Everyone,

I have a excel in which date is in ODate

I want to convert it into dd-MM-yyyy

Need help urgently

[rlgandu (Rajyalakshmi Gandu)]

@SP_Bot

DateTime.FromOADate(Double.Parse(yourODate)).ToString("dd-MM-yyyy")

[ppr (Peter Preuss)]

DateTime.FromOADate(yourDoubleVar).toString(“dd-MM-yyyy”)

[Nawazish_Ahmad]

Hi @SP_Bot

Assign the Value in Input

Try This:
DateTime.FromOADate(Input).ToString(“dd-MM-yyyy”)

Hope it will helps you
Cheers!!

[Parvathy (PS Parvathy)]

Hi @SP_Bot

Try this:

DateTime.FromOADate(CDbl(Strinput.ToString)).ToString("dd-MM-yyyy")

Regards

[Parvathy (PS Parvathy)]

Hi @SP_Bot

If you data in datatable then use the below code in invoke code

dt.AsEnumerable().ToList().ForEach(Sub(row) row("DateColumn") = DateTime.FromOADate(CDbl(row("DateColumn"))).ToString("dd-MM-yyyy"))

Regards

[SP_Bot]

@ppr @Nawazish_Ahmad @rlgandu @Parvathy

[ppr (Peter Preuss)]

Change the inverted doublequotes to "

[Nawazish_Ahmad]

@SP_Bot

Please use proper proper DOUBLE QUOTES

Happy Automation:)

[Parvathy (PS Parvathy)]

Hi @SP_Bot

Retype the Double quotes . The error will be gone.

Regards

[SP_Bot]

Great you all genius
Thanks for quick response