I am looking for a expression for comparing the date from table ( Scrapped) and get the row index of most recent one ( latest / nearest to current system date)
Use sort datatable activity and sort the datatable dt1 (scrapped datatable) by descending order (give date column name in property) and store it in the datatable variable name dt2.
Use assign activity and store the index to a variable result = dt2.rows(0)(0).tostring to get the row Index as order Id is incrementing by 1 for each Record.
The value printed is β2008-11-11β so that means index is β0β right?
With this one: SortedDT.Rows(0)(0).ToString , the output printed is β1β. little confused what is that second (0) there and what the output it is printing.