List item sorting issue when group by Month

Question

_{Friday, December 6, 2013 4:53 AM}

Hi,

I am having one list which contains month and year coloumn

i have group them according to year and then month

But when i group them by month it sort as per alphabatic order but i want to sort it as january,February,March,April etc in this order.

Varsha Patil

All replies (4)

_{Friday, December 6, 2013 5:01 AM ✅Answered}

you need a calculate column for this, check this one

http://www.iotap.com/Blog/tabid/673/entryid/96/Grouping-a-Sharepoint-list-by-Month-Name-Year.aspx

another one

http://techtrainingnotes.blogspot.com/2012/02/sharepoint-group-by-year-or-month-in.html

Please remember to mark your question as answered &Vote helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -WS MCITP(SharePoint 2010, 2013) Blog: http://wscheema.com/blog

_{Friday, December 6, 2013 12:37 PM ✅Answered}

Then you end up with a viewing feature that makes a user interface ugly.  The key to this is how the Month / Year Column is set up.  If they're choice fields that are presented as drop down choices, then renaming them with numeric prefixes work, but it's rather ugly.

If you're using a DateField column, than you have more freedom.  What I tend to do is

1. Use a Date / Column field where possible
2. Create a a calculated column that takes this field and returns a number (1-12).  Set this as a number with 1 decimal point
3. You can then sort on these as needed.  The decimal point is handy incase you want to build views against them.  I'm not sure on the reasoning but it doesn't work in the view definition field otherwise.

All done.

Steven Andrews
SharePoint Business Analyst: LiveNation Entertainment
Blog: baron72.wordpress.com
Twitter: Follow @backpackerd00d
My Wiki Articles: CodePlex Corner Series
Please remember to mark your question as "answered" if this solves (or helps) your problem.

_{Friday, December 6, 2013 11:44 AM}

The issue is that if Months are Texts, they are sorted alphabetically, so the order is April, August, December, ...
I have yet not figured out a simple way to design this, except using numeric months or prefixing the months with 01 - January, 02 - February, 03 - March, 04 - April, etc ..

So far, I have the horrible solution of using a "Month" Lookup column from a auxiliar "Month" list, show the textual field in the view but order by the Lookup ID ( where ID 1 = January, ID 2 = February, so on .. )

This is a horrible solution because I want all my custom lists to be saved as template and "featurized" and I can't do this with a Lookup.

_{Friday, December 6, 2013 12:21 PM}

Yes, the simplest solution is to rename the values of the Month field with the number of the respective month like 01 - Jan, 02 - Feb,... 12 - Dec.

Owens G. Jesse