Calculated formula contains a syntax error or is not supported

Brass Contributor

I've a Date and Time column Revision Date.
And try to create a Calculated column Revision Date (dd mmm yyyy). It because I want to change a look of date and set to (dd mmm yyyy).
So, after added a formula =TEXT(Revision Date,"dd-mmm-yyyy"), I have an Error "The formula contains a syntax error or is not supported".
Could you help me please, how I can fix this problem?

2 Replies
You don't need to post twice and I've answered it on your other post.
best response confirmed by Pavel48n0sh (Brass Contributor)

@Pavel48n0sh Answer already given on your another post here.


Just in case anyone else visits this thread in future looking for answer to similar question, here's the working formula: 


=TEXT([Revision Date],"dd-mmm-yyyy")


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.