Sharepoint Forum

 
Home » Forum » Sharepoint       Ask a questionRSS Feeds

Grouping News Stories by Month

  Asked By: Johnpaul Zamora         Date: Aug 24, 2005      Category: Sharepoint      Views: 205
 

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?

Tagged:          

 

3 Answers Found

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

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, 2005       

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, 2005       

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.


Your Answer
  • Answer should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].