Second-highest date

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

Hi @sayed.tabrez ,

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.


Thank You for help

1 Like

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