Get the month name in calculated column
Filed Under (SharePoint) by Boris Gomiunik on 07-05-2009
Before you go and make a long series of if clauses check the following:
If you need to get the month name from a date (and time) field, simply use the following formula:
=TEXT([DateField];"mmmm")
if you just need the three letters of the month name, replace “mmmm” with “mmm”. Now the problem may arise if you try to sort/group by month name. To keep them sorted, you can add the month number in front
=TEXT(month([DateField]); "00")&" "&TEXT([DateField];"mmmm")
Technorati Tags: SharePoint,Calculated field
Instead of this:
=TEXT([DateField];”mmmm”)
Try:
=TEXT([DateField],”mmmm”)
… comma instead of semi-colon
Exactly. It depends on your locale. If you’re using dot as a decimal separator, then the parameters separator in function becomes comma. In Slovenia, where I’m from the decimal separator is comma and thus you need function parameters separated by semicolon. Thanks for pointing out, Ken!
[...] we create an additional column for displaying day of the week. The details are described in this post only using the day name. The formula [...]
[...] Get the month name in calculated column | SharePoint (tags: sharepoint2007 administration calculated-column development) [...]