Forum Discussion

Pavel48n0sh's avatar
Pavel48n0sh
Brass Contributor
Jul 29, 2022
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...
Document Library
hybrid
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Jul 29, 2022

    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.

ganeshsanap's avatar
ganeshsanap
MVP
Jul 29, 2022

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.

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Jul 29, 2022

    ganeshsanap which was exactly the solution I gave.

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

    • ganeshsanap's avatar
      ganeshsanap
      MVP
      Jul 31, 2022

      Thanks for your comment RobElliott. I am just trying to help OP( Pavel48n0sh ) here.

       

      Here are the things I provided in my response & thoughts behind it:

      1. Complete formula with correct syntax: OP can directly copy-paste & try it.
      2. Note about regional/language settings: This may also be the problem for OP while using above formula. I have seen many people face this problem while using comma in formula instead of using semicolon.
      3. Link to Microsoft official documentation: If above suggestions do not work for OP, he/she can read the official documentation, check for correct syntax and write the correct formula on his/her own now & in future.

      If OP confirms my above response does not help him/her in any way, I will delete my previous response happily.

      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.

Resources