Second-highest date

sayed.tabrez · January 31, 2023, 6:24am

like a column of birth of date, I want second-highest date

supermanPunch · January 31, 2023, 6:40am

Assuming you have already read the Data from the Excel as a Datatable, you can Check with the below Expression :

SecondHighestDate = DT.AsEnumerable.OrderByDescending(Function(x)CDate(x("YourBirthDateColumnName").ToString))(1).ToString

Here, SecondHighestDate is of the Type String, and DT is the Datatable variable.

Let us know if the above expression does not work.

sayed.tabrez · January 31, 2023, 6:59am

Thank You for help

system · February 3, 2023, 7:00am

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