Stump the Panel

Paul Grenier, Lead Moderator

Stump the Panel » End Users and Information Workers

1. 

   illegal operation
   Member

   Hi,
   I've read the info in this post
   http://www.endusersharepoint.com/STP/topic/month-category-issue#post-3338

   I'm having a couple problems.

   The first is the sorting of the months,
   for some reason it's sorting the months alpabetical, instead of placing the months in the correct order. For example December is listing right after August.

   The next problem I'm having is, if I enter a bunch of events for April 09 it groups them just fine. But if I enter a event for April 2010, it groups them together with the 09 events. Is there a way to make it place the April 2010 at the end of the list?

   I would want it look like this

   April 2009
   ..4-20-09
   ....Event 1
   ....Event 2
   ..4-21-09
   ....event 1
   June 2009
   ..6-1-09
   ....Event 1
   ....Event 2

   so and so on

   April 2010
   ..4-1-10
   ....Event 1

   Posted 3 days ago #
2. 

   illegal operation
   Member

   OK, I got the grouping fixed by doing this. So the 2009 and 2010 events aren't listed together

   =TEXT(DATE(YEAR([Event Date:]),MONTH([Event Date:]),"1"),"MMMM/YYYY")

   But, I still haven't figured out the sorting. It's now putting April 2010 right after April 2009

   and December and November are still appearing in the middle of the list.

   Posted 3 days ago #
3. 

   illegal operation
   Member

   There should be a way to sort the groups the way I want right?
   I've been messing with it, and just can't seem to get them work.

   Posted 2 days ago #
4. 

   GeorgeWNYC
   Member

   Well, there are limits to everything.
   Grouping requires a sort order, and J will never come before F.
   So I suggest you create a calculated column with

   =TEXT([Event Date:] ,"yyyy-mm MMMM YYYY ")

   Posted 2 days ago #
5. 

   Peter Allen
   Member

   Here is a post that I have on it. Basically the same as George outlined.

   http://www.bitsofsharepoint.com/BlogPoint/Lists/Posts/Post.aspx?ID=5

   I would do YYYY-MM-DD. This will get your sort order correct.

   Now to have your grouping then you would have YYYY-MM.

   These would be two different columns, but they would be calculated columns. First one you can sort on and the second you can group by.

   Hope this helps.

   Posted 1 day ago #

RSS feed for this topic

Reply

You must log in to post.