Get the Latest row data based on the date

I have following datatable :

Column1 Column2
Template1 12:57 pm
Template2 1:00 pm

here, I need to get the latest data, based on the date(column2), however challenge is column2 is of type string as reading it from excel.

Output required : “Template2”

I’m looking for .NET expression. I already have the solution.

Any help would be appreciated.

@Palaniyappan @pravin_calvin @Gokul001


Hi @Shantanu_More,

One quick solution can be Try changing the format of required column then use Sort datatable activity in descending order which can then give your required result.


Yeh, I already have that solution. I’m trying the find using the any .net expression. Which would cover all the points.