I am trying to get the month from a date field with the help of calculated column. However I get this syntax error whenever I want to submit the formula:

Error The formula contains a syntax error or is not supported.

the default language of our site is German and [datum, von] is a date field.


Below function gives you month in digit.

=TEXT([Date],"mm")   =>     returns 01 if date is 15-Jan-2014

Below function gives you month name

=TEXT([Date],"mmmm")  =>    returns January if date is 15-Jan-2014

Below function gives you short month name

=TEXT([Date],"mmm")   =>    returns Jan if date is 15-Jan-2014
| improve this answer | |
  • :I have german month name in sharepoint list ,is there any way to convert month in Number? – Ankush Jul 27 at 12:38

Try to use this one =TEXT([DateField];"mmmm"). I usually have error if use ',' instead of ';' in formula. My site language is Russian and it then translates automatically if I write first in English.

Reference: Get the month name in calculated column

| improve this answer | |
  • 1
    don't forget to mark this as answer ;) – Ksesh Aug 7 '13 at 10:55

It would help if you shared your formula. Try:

=TEXT([Date Column],"MMMM")
| improve this answer | |
  • sorry I forgot to write my formula. it is the formula: =TEXT([Datum, von],"MMMM") – d d Aug 6 '13 at 21:05
  • maybe I should write it in another way for a site with German language. it seems that there are some small differences in the formula syntax in German: msdn.microsoft.com/de-de/library/bb862071(v=office.14).aspx – d d Aug 6 '13 at 21:08

For sorting purposes (i.e. Ascending sort and Descending sort) on the month I usually do the following:

=CONCATENATE(TEXT([Some Date Column],"MM")," : ",TEXT([Some Date Column],"MMM"))

This results in the format:

01 : Jan

Which then allows you to set up a View where you can correctly sort by Month.

| improve this answer | |

This will return a number from 1-12 and a Null when the date column is blank.

=IF(ISBLANK([Some Date Colum]),"",TEXT([Some Date Colum],"mm"))
| improve this answer | |

The above link to the solution for getting rid of the "02", "02" values is broken ... however, I have posted a solution for that on my blog which will work just as well: http://thesharepointhive.blogspot.com/2015/12/render-sharepoint-list-headers-in-order.html

| improve this answer | |

Last date of the month (this works for leap year as well)

QDate = August 2015


| improve this answer | |

I selected a date of 3 February 2018 in a custom list date column (named "Date") and then created a calculated column with this formula:

=CONCATENATE(TEXT([Date],"DDD")," ",TEXT([Date],"DD")," ",TEXT([Date],"MMM"))

The calculated column appears as: Sat 03 Feb

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.