9

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.

11

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
9

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

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

It would help if you shared your formula. Try:

=TEXT([Date Column],"MMMM")
  • 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
1

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.

1

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"))
1

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

0

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

QDate = August 2015

=DATE(YEAR(QDate),MONTH(QDate)+1,DAY(QDate))

0

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

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.