Hello Everyone,
I have a excel in which date is in ODate
I want to convert it into dd-MM-yyyy
Need help urgently
Hello Everyone,
I have a excel in which date is in ODate
I want to convert it into dd-MM-yyyy
Need help urgently
DateTime.FromOADate(Double.Parse(yourODate)).ToString("dd-MM-yyyy")
DateTime.FromOADate(yourDoubleVar).toString(“dd-MM-yyyy”)
Hi @SP_Bot
Assign the Value in Input
Try This:
DateTime.FromOADate(Input).ToString(“dd-MM-yyyy”)
Hope it will helps you
Cheers!!
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
Change the inverted doublequotes to "
Great you all genius
Thanks for quick response
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.