Date in data table

Help Activities
, , ,
1

I have excel dates which look like
image
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”

2

Hi @plamenov.plamen ,

Could you please elaborate more about your requirement.

Thanks,
Sanjit

3

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")

Regards,
NaNi

4

Hi @plamenov.plamen

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

Please refer the below flow,
image

image
image736×170 8.29 KB

Regards,
Vasanth Kumar

5

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()

image
image1070×270 22 KB

then u can get all dates values

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

Thanks Man
VP