Date in data table

I have excel dates which look like
this the format in excel is “date” How can I assign all the dates from the table so that the robot remembers them for next actions? I tried with For Each Data Row, but after exiting the loop, the robot only remembers the last date. I need to remember everyone.the form of the date must be “dd.MM.yyyy”

Hi @plamenov.plamen ,

Could you please elaborate more about your requirement.


Hi! @plamenov.plamen

Welcome to community!

What do you mean by the remembering the date? Where do you want to use this date?

For conversion of the date follow this.

str_datetime = Datetime.ParseExact(Strinput.ToString, "yyyy-MM-dd", System.Globalization.CultureInfo.InvariantCulture).ToString("dd.MM.yyyy")


Hi @plamenov.plamen

to store date you have to create an array or list,

Please refer the below flow,

Vasanth Kumar

Hi @plamenov.plamen

Note: If you want to keep all date in the Single variable u have to use Array/List
Left side: ArrayVariable
Value side:
Dt1.AsEnumerable().select(Function(row) datetime.ParseExact((row("date").ToString),"yyyy-MM-dd",system.Globalization.CultureInfo.InvariantCulture).ToString("dd.MM.yyyy")).ToArray()

then u can get all dates values

Note: Make sure the after read the Excel date format as “yyyy/MM,dd”

Thanks Man