Sorting Array of date strings

Arsi · October 18th, 2004, 05:12 PM

Hello,

I'm trying to sort a string array of dates using Array.Sort(myArray). It is a one-dimensional array. I am having trouble sorting the dates. Can someone point me in the right direction? It will be greatly appreciated.

Array.Sort(myArray) sorts the array according to month but does not consider the days or the years. What can I do to fix this?

*******(*)*******

Kep · October 18th, 2004, 06:00 PM

You have a couple of options here. Firstly you can format the dates as strings using YYYYMMDD with no separators. This should ensure that dates are sorted correctly.

The other way to do it is define a new type which stores a DateTime value and implements the IComparable interface. You could then store each date, in this new class, in an object array and the sort function should work correctly.

Kep.

Arsi · October 19th, 2004, 01:01 PM

Thank you for your help! I appreciate it.

I tried using:
for (i = 1467; i < 1470; i++)
            {
                if (i + 1 != 1471)
                {
                    strOne = strSort[i];
                    strTwo = strSort[i+1];
                    Comparer.DefaultInvariant.Compare(strOne, strTwo);
                }
            }
but it does not want to sort the dates correctly. What am I doing wrong? I am new to C#. I know I can do it manually, but I've never actually used C# methods to do this task.

*******(*)*******

Kep · October 19th, 2004, 06:03 PM

How does the code you've given sort an array? It doesn't store the result anywhere?
As I said, all you have to do is store the strings in your array like YYYYMMDD and then call...

Code:

Array.Sort(myArray)

Kep.

Arsi · October 22nd, 2004, 04:18 PM

Ok. Nevermind. It is not working...I have to set to storing the dates as integer values in a string array. For example: 1/31/2004 as "1312004" but its not working correctly. Can you please help me some more? Thanks.

*******(*)*******