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)

4 Likes

@Ramkumar_KAMARAJ
Welcome to the forum

Just open a new topic on your case and get individually help. Maybe you can also share some sample data with us (e.g. we can see the date formats)

What If I dont know how many records updated recently?
I want to select all records which updated recently. What action need to do?


getting error in culutreinfo not declared

add System.Globalization namespace
import_systemglobalization

sorry i forgot to import it …
i have one more doubt
i got the date in a variable now i have to find the rows which have that same latest date and identify the rows with same latest date

thats means in a datatable i need the rows with same latest date ???

Just open a new topic for your case and get individually support. Feel free to reference me from there

i have created please look into it