Can't Convert into DataTime Format

I have to convert the String Value into DataTime Value…

I am having dataTime input from excel file like “9/26/2017”, but i am using Bot to pick the value from excel it will show like "43007"

Alternatively, i am using Format Value activity but i can’t achieve to convert into DataTime Format.

Can anyone give a solution for this…?

Poovarasan Guna

Try this out.
DateTime yourDateVar = DateTime.FromOADate(43007)
For result:
yourDateVar .ToString(“MM-dd-yyyy”)


Thank You @ddpadil,

1 Like