SOLVED

Calculated formula contains a syntax error or is not supported

Occasional Contributor

Hi!
I've a Date and Time column Revision Date.
Screenshot_201.png
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).
Screenshot_202.png
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".
Screenshot_203.png
Could you help me please, how I can fix this problem?
Thx!

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

@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.