SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Alrite so heres my issue:

Sharepoint 2010 i have inserted the following excel code into my calculated field:


so then i did a group by in my list.

THis is what it looks like:

October -item 8 (date i used was some random date in october, ie 10/1/2012) November -item 7 (date i used was some random date in november ie 10/5/2012)

The issue here is that I wanted months to be sorted on teh current month, dynamically.

i.e November -item blah October -item blah

Any help is appreciated.


share|improve this question
Regardless of year? – Robert Kaucher Nov 9 '12 at 16:35
up vote 1 down vote accepted

I am assuming that by current month you do in fact mean the current month of the current year.

Create a column called Month_Digit and hide it from the New/Edit/Disp forms and any applicable views. It should be calculated and of type Number: =MONTH(Created)

Do the same with a field called Year: =YEAR(Created)

In your view sort by Year (descending), then by Month_Digit (descending). Then Group by the text value of Month.

The problem is that =TEXT(Created, "mmmm") is just a text string and you cannot sort text by anything other than the collation of a given alphabet. So you need to add the numeric representation of the months.

share|improve this answer
thanks a lot!This fixes a lot of the issues, now i just need to be able to sort the group by part. – will Nov 9 '12 at 23:27
btw, i really like how u explained what i did wrong, that was really helpful – will Nov 10 '12 at 0:10
Thank you! I was very glad to help. – Robert Kaucher Nov 10 '12 at 2:38


Take one more calculated column and set =MONTH(Created) and sort the view by this column! If you have several years data as well, then you can create another calculated column for Year and first Sort desc by Year and then desc by Month!

I hope this will achieve what you want...

share|improve this answer

I did something similar (granted its SP 2007) but just sorting by month didn't help because the list was spanning into multiple years. I included the Abbreviated Month and Year then just grouped on that field.

=TEXT(Created,"mmm YYYY")

Hope that helps.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.