Get the Latest row data based on the date

Help Studio
, ,
1

Hi,
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

Thanks,
Shantanu

2

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.

Thanks

3

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