DataRow selection based based on most recent date

Hi People,
I have built a workflow that filters a data table based on an input, how then do i select a row based on the most recent date from the filtered data table?

Do you have a collum with the dates?
if yes try to sort the table with date collumn then choose the first row.

1 Like

Yes I have a column for dates, do i need to convert the column to datetime format?

1 Like

Yes you have to do it

1 Like

Please how do i successfully achieve the column conversion please

@John_Dara
ensure that your data is read into a datatable
check if parsing the date string into datetime is working
Ensure System.Globalization is imported to the namspaces (Panels nearby the variables planels)

For Retrieval find a helper here
GetRecentDateFromDataTable.xaml (6.5 KB)

3 Likes