Can't Convert into DataTime Format

excel
studio

#1

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…?

Regards,
Poovarasan Guna


#2

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


#4

Thank You @ddpadil,