How to get the date value from excel?

Help
, ,
1

Hello ,
I am reading the excel and the data is in the datatable dt. I want to read the date from start date
column
I am using this expression for this:- dt.rows(1).item(“Start Date”).tostring
but I am getting no value as output

1 Like
2

The expression would be like this in a write line activity
Datatable.Rows(rowindex)(“yourcolumnname”).ToString

Or we can use GET ROW ITEM ACTIVITY

https://docs.uipath.com/activities/docs/get-row-item

Hope this would help you
Kindly try this and let know for any queries or clarification

Cheers @Karan28

3

here the date is in this format
11/06/2019

1 Like
4

So this expression will get you the value in this format
11/06/2019 00:00:00

Cheers @Karan28

5

Thankyou buddy , for this but one more doubt

I am getting the value in dd/MM/yyyy format and i need to change it into MM/dd/yyyy format

6

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