cancel
Showing results for 
Search instead for 
Did you mean: 

Not able to retrive the date from the excel sheet.

SOLVED
Highlighted
Occasional Contributor

Not able to retrive the date from the excel sheet.

Not able to retrive the date from the excel sheet.

 

Excel I am using is professional 2013.

 

When I read a date from excel it is retriving as text hence for date 18/03/2019

it retrives as 43542.  How can can I get it in the date format?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Occasional Contributor

Re: Not able to retrive the date from the excel sheet.

Issue resolved 

I had updated the excel from standard to pro 2013. When I made changes and saved the excel and rerun the scripts the issue got some how solved.

View solution in original post

1 REPLY 1
Highlighted
Occasional Contributor

Re: Not able to retrive the date from the excel sheet.

Issue resolved 

I had updated the excel from standard to pro 2013. When I made changes and saved the excel and rerun the scripts the issue got some how solved.

View solution in original post

New Here?
Join us and watch the welcome video:
Announcements
Script Wanted
Let's start July with new challenges!

Create a script to pass custom command-line arguments as a test parameter for the TechCorner tag!

Will you dare to take the challenge?


Top Kudoed Authors