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
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.