GET VALUE DATE TIME FROM EXCEL

Help Activities
, ,
1

so i have an excel file with value of date time,
the problem is when i get the value with for each row
the robot get the data but inn general format which will make it into
image
instead i want to get this value which is in the date format
image

any idea ?

2

How is the value in excel…it is in which format?

3

its in date format , buts omehow robot get it in general format

4

Hello @Ahmad_Rais

I hope the first screenshot is the value which robot captures and the second screenshot is the value in excel. Correct if I’m wrong.

Did you check it in a message box? Just try to print it in message box.

I hope while writing to excel, the format of the cells are not date time. Thats why its not showing in the required format.

5

i just log it using , row(column).tostring to see the value , when i try to to row(column).ToString(“dd/MM/yyyy”) it says cannnoot convert string to integer

6

row(column).tostring whats the output?

7

Convert.ToDateTime(variableHere)…Try this

8

“Log Message: String was not recognized as a valid DateTime.”,

9

Please share the excel file

10

have a look here
grafik

11

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.