How to get the date value from excel?

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

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

Or we can use GET ROW ITEM ACTIVITY

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

Cheers @Karan28

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

1 Like

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

Cheers @Karan28

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

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