How to find max value in list

[Sree_Krishnan_vellinezhi]

I have list(of string) in which contains the folder names as dates ‘MM.dd.yy’ and i need to find the latest date from this list

@ppr @supermanPunch

[Rahul_Unnikrishnan]

Hello @Sree_Krishnan_vellinezhi

Please refer to the below post.

Sort an Array of Strings containing Dates by Date

here you go with a xaml hope its resolved datte.zip (2.1 KB) Cheers @Lorenz_Goring

[sarathi125 (Parthasarathi)]

@Sree_Krishnan_vellinezhi,

Try with the below steps.

1. Create a variable as “lstDates” as List(Of DateTime) datatype
2. Then use assign activity to convert your datetime string list to List(Of DateTime)
   lstDates= yourListStringDate.[Select](Function(x) DateTime.ParseExact(x, “MM…dd.yy”, Nothing)).ToList()
3. You can get min date → lstDates.Min()
4. You can get maxdate → lstDates.Max()

This will return as datetime datatype

[ppr (Peter Preuss)]

@Sree_Krishnan_vellinezhi

‘MM.dd.yy’

Some sample values would be helpfully. Give a try on following:

myMaxDate | DateTime =

(From x in YourList
let m = System.Text.RegularExpressions.Regex.Match(x, "\d{2}\.\d{2}\.\d{2}")
Where m.Success
Let dp = DateTime.ParseExact(m.Value, "MM.dd.yy", System.Globalization.CultureInfo.InvariantCulture)
Order by dp.Date
Select v = dp).Last()

[Sree_Krishnan_vellinezhi]

This is array not list @Rahul_Unnikrishnan

[Sree_Krishnan_vellinezhi]

@ppr

(From x in YourList
let m = System.Text.RegularExpressions.Regex.Match(x, "\d{2}\.\d{2}\.\d{2}")
Where m.Success
Let dp = DateTime.ParseExact(m.Value, "MM.dd.yy", System.Globalization..CultureInfo.InvariantCulture)
Order by dp.Date
Select v = dp).Last()

My actual process is i have a path in which there are several folders named with dates mm.dd.yy i need to get only the latest date folder (excluding the nondate folders)
(

Note:- Cant find through modified date because all folders are created same day itself)

[ppr (Peter Preuss)]

LINQ should work for this including defensive handling of non dates. Had you tried?

[Sree_Krishnan_vellinezhi]

@ppr

(From x in YourList
let m = System.Text.RegularExpressions.Regex.Match(x, "\d{2}\.\d{2}\.\d{2}")
Where m.Success
Let dp = DateTime.ParseExact(m.Value, "MM.dd.yy", System.Globalization.CultureInfo.InvariantCulture)
Order by dp.Date
Select v = dp).Last()

Yes @ppr it worked.
Thanks