Hello, Im new in UiPath automation, so i need that from excel column would take the line with the latest date.The date is at the lines end 4 digits. Like in the column is EN 13480-3:2017, EN 13480-3:2017/A3:2019, EN 13480-3:2017/A2:2020, , and i need that it would take the line with the latest da…

Hello, Please check the below options (vb codes), it should work LINQ LatestRow = dtData.AsEnumerable(). OrderByDescending(Function(row) Convert.ToInt32(row("ColumnName").ToString().Substring(row("ColumnName").ToString().Length - 4))).First() SELECT Query Dim latestRow As DataRow = dtData.S…

Sort by the last 4 digits, latest date

Help Studio

system (system) Closed December 30, 2024, 9:56am 4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
How to get value based latest date? Activities uiautomation , activities , question	7	901	July 17, 2022
How to extract the latest date from Excel using uipath Activities excel , studio	3	306	September 12, 2023
How to pick latest date in excel using UiPath Activities excel , activities , studio	29	2109	October 1, 2022
How to pick latest date from Excel and storing the latest date in string variable using uipath Activities excel	6	337	September 29, 2023
"Sort Data Table" activity not sorting Activities excel , activities , question	3	797	November 8, 2023

Sort by the last 4 digits, latest date

Related topics