Forum Discussion
Solved
Calculated formula contains a syntax error or is not supported
Hi! 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). S...
Pavel48n0sh Use below formula:
=TEXT([Revision Date],"dd-mmm-yyyy")Note: Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So, in that case use semicolon(;) instead of comma(,).
Documentation: Calculated Date and time formulas
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.
Pavel48n0sh in your formula put Revision Date inside square brackets/parentheses.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)