Datatable and click on the latest date

Help Activities
, , ,
1

Hi Experts,

Please help on how to automate the following process. Let’s say i’ve extracted the list to a datatable.

  1. If parameter set is “AsOf_1MthAgo” and Start Time is the latest. In this case, i want to extract the data for 21Oct23 and not 11Oct23.

How can i achieve that. Thank you.

Capture
Capture981×530 52.9 KB

2

@Joanna2

Use the following and get the latest job ID

Dt.AsEnumerable.Where(function(x) x("Parameter set").ToString.Equals("AsOf11monthsAgo")).OrderByDescending(function(x) DateTime.Parse(x("Starttime").ToString,"MMM dd, yyyy hh:mm:ss tt",System.Globalization.CultureInfo.InvariantCulture))(0)("JobID").ToString

Now use the above job id as variable in the innertext property of the column

Selector looks like this

<webctrl tag='TD' tablecol='7' innertext='{{jobidvariable}}' />

Cheers