
Hi everyone,
I need some help. I exctracted data from web page, it 's about a column of dates and I want to write to excel only the earliest date. What steps I have to follow to isolate the earliest date and write it in a new excel?
Thanks.
Till now I have made the follow steps.
Hi @evamits
extract the table of one column of dates and then do the following
You can use run .net action
configure the requirements by following the link below
https://youtu.be/gyscFdPdCCQ?si=vBZzKYXMukK2zcmd
then write the linq as shown in below images
Here Due on id the column name in my scenario
the output will be the datatable which contains latest date
from that you can get the date as datatable[rowindex][columnindex]
For example:
ExcelData[0][0]
Please feel free to connect if you have any doubts
Hope this helps,
Usha jyothi.