Extract Date from excel file

HI @Mohamed_Hassan1

Welcome to UiPath community

once after reading datatable pass that dt to FOR EACH ROW activity as input and inside the loop use a assign activity like this

row(“column name of date”) = row(“Column name of date”).ToString.SubString(0,10).ToString.Trim

or
if we want in specific format we can mention that format in ToString(format we want)

row(“Column name of date”) = Convert.ToDatetime(CurrentRow(“Column name of date”)).ToString(“yyyy-MM-dd”)

for more details on diffferent date format

Hope this would help you

Cheers

1 Like