Date conversion issue, have a column of date need to find the latest date in the column

Help Studio
1

I have a column of date from which i need to select the lattest date.
Date (column name)
12-11-2015 15:31:10CET
04-05-2020 14:05:01CET
30-10-2015 10:27:03CET
25-12-2018 02:17:18CET
12-12-2017 10:56:33CET
02-02-2016 11:08:25CET
19-10-2015 10:17:16CET
24-06-2016 10:08:52CET
26-10-2015 17:03:42CET
02-08-2018 16:23:22CET

2

Hi @ash864u

Did u tried to sort the datatable ?

1 Like
3

Yep i tried using

4

Hi @ash864u

Try this

sample workflow.zip (4.0 MB)

Regards,

Nived N

Happy Automation

1 Like
5

Hey Nived, thanks for the solution, can please tell me how to get the output only in(MM-dd-yyyy) format

6

the output i had shown in message box is

dt1.Rows(0)(0).ToString

so change it to

dt1.Rows(0)(0).Replace(“CET”,“”).ToString(“dd-MM-yyyy”)

Try this

Regards,

Nived N

Happy Automation

7

It is giving a error “Option strict On disallows late binding”