We looked at this a while back.
Say you've got 7 news stories per week and each has a "Release Date"
field and a status field that either "Draft," "Current,"
or "Archive."
You want "Current" stories to appear on an area's home space which
also has a link to "Archives". No sweat.
but the "Archives" list gets clutterred really quickly, so we'd like
to group them by month, but, and here's the catch, we want the
months to be listed in chronological order.
I see I can use a calculated column in my list for "Month" and use
the column formula: =TEXT([Release date], "mmmm")
But, that puts all of last year's August stories in with this year's
August stories. Bad.
So I expand the formula to : =TEXT([Release date], "yyyy")& " "& TEXT
([Release date], "mmmm")
So that creates the text "2005 August" but then it alphabetizes the
months. So that "2005 August" is at the top and then "2005
February" and then "2005 September"
There's no way to tell the group to stack the list up in
chronological order is there?