Get the month name in calculated column
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!