SharePoint list formula fields – created month name

Few days back one our users wanted to group all the items in a MOSS list by the created month. I just created a new filed and made it a formula field and just applied the following, then used this field to group the list items.

=CHOOSE(MONTH(Created),”January”,”February”,”March”,”April”,”May”,”June”,”July”,”August”,
“September”,”October”,”November”,”December”)

Happy formula writing J

Advertisements

One thought on “SharePoint list formula fields – created month name

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s