How to sort different dates in and get the Max date from those

[vIns]

Please use DotNetFactory object to simplify this.

Here i assume that you get the dates from the application and store it in an array

Code:

Dim arr(3)
arr(0) = "Thursday, September 13, 2012"
arr(1) = "Saturday, September 08, 2012"
arr(2) = "Friday, December 14, 2012"
arr(3) = "Friday, November 23, 2012"

This is the part sorts the date and gives you the max date in the required format

Code:

Set SystemDateTime = DotNetFactory.CreateInstance( "System.DateTime" )
Set ArrayList = DotNetFactory.CreateInstance( "System.Collections.ArrayList")
For i =0 To 3
    Set DateTime = SystemDateTime.Parse(arr(i))
    ArrayList.Add DateTime
Next
ArrayList.Sort
ArrayList.Reverse

Print "Result=" &ArrayList.item(0).GetDateTimeFormats().GetValue(7)