Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Grouping News Stories by Month

  Asked By: Johnpaul    Date: Aug 24    Category: Sharepoint    Views: 1290

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?



3 Answers Found

Answer #1    Answered By: Rashawn Hopper     Answered On: Aug 24

I don’t suppose you’ve tried…

=TEXT([Release date], “yyyy”) & “/” & TEXT([Release Date], “mm”) & “ (“ & TEXT([Release date], “mmmm”) & “)”

Have you?

Answer #2    Answered By: Horace Coffey     Answered On: Aug 24

Now, I've tried it and it works just fine.

Although, somehow your up and down double quotes make it blow up.

I used:

=TEXT([Release Date],"yyyy")&"/"&TEXT([Release Date],"mm")&"("&TEXT
([Release Date],"mmmm")&")"

Where did the up and down double quotes come from?

Answer #3    Answered By: Rigoberto Beard     Answered On: Aug 24

The quotes are a beautiful side effect of using Word as your email editor.

Didn't find what you were looking for? Find more on Grouping News Stories by Month Or get search suggestion and latest updates.