Second-highest date

Help Studio
2

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.

2 Likes