Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Alrite so heres my issue:

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

=TEXT(Created,"mmmm")

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.

Thanks

share|improve this question
    
Regardless of year? –  Robert Kaucher Nov 9 '12 at 16:35
add comment

3 Answers

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
add comment

Will,

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
add comment

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
add comment

Your Answer

 
discard

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.