This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(48, 44%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hello,
I need a calculated filed that show extended month from another date field.
When I put the formula in SPO, I get the error :
Sorry, something went wrong
The formula contains a syntax error or is not supported.
Formula; =TEXT(DATEFIELDNAME,"mmmm")
THANK YOU
I am currently looking into this issue and will give you an update as soon as possible.
Thank you for your understanding and support.
I found the solution by myself
=TEXT(DATEFIELDNAME;"mmmm")
SharePoint online needs ; instead ,
Thank you for your sharing! It will be beneficial to others in this community who meet the same issue in the future.
Per my research and test, we could use following formula to get month from Date Time column:
=TEXT([Date T],"mmmm")
Note that if Calculated Columns have spaces, it’s need to be enclosed in square brackets when used in formulas.
In calculated column, we could use “Add to formula” directly to make sure the inserted column is right.
If I use a semicolon instead of a comma, an error occurs.
Refer to common formulas in this article, they all use “,”, rather than “;”.
If this is not feasible for you, please feel free to reply.
Hello,
thank you for your reply
I can confirm that the formulas in the doc DO NOT WORK in my tenant (italian localization). Works only if I substitute , with ;
Probably depends on local settings.