Loading

how to get month only column in sharepoint list

Vishal Singh

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.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palaniappan10y ago
Accepted answer
For example [Created] is the datetime column, we can get month alone using below formula.
=Text([Created], "MMMM") : This will return the full month name
=Text([Created], "MMM") : This will return first 3 letters of the month name
=Text([Created], "MM") : This will return integer month
+1