sort an array with dates

[Albano]

Hi,

Someane have a code to sort an array fill with dates in the fromat dd/mm/yy.

Thanks,

Albano de Sá

 

[EBGreen]

This thread should get you started. It is discussing alpabetic sorting, but the priciples are the same for dates. Post back with your code or any problems.

[blue]"Well, once again my friend, we find that science is a two headed beast. One head is nice, it gives us aspirin and other modern conveniences,...but the other head of science is BAD! Oh, beware the other head of science, Arthur; it bites!!" - The Tick[/blue]

 

[PHV]

Brute force method (bubble sort):
Say the array of dates is a()
[tt]
For i=0 To UBound(a)
For j=i+1 To UBound(a)
If CDate(a(i))>CDate(a(j)) Then
tmp=a(i)
a(i)=a(j)
a(j)=tmp
End If
Next
Next[/tt]

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Albano]

Hi,

What thread TomThumbKP, I think you forget the link.

PHV the sort code only sort dates by day, do you have someting that sort by day asn month.

Thanks,

Albano