Forum Discussion

Jonas_Daragas's avatar
Jonas_Daragas
Copper Contributor
Mar 28, 2023

Get the year from other column

Hi     I'm creating a new column in my Sharepoint List. I'm using a calculated value for this column that extracts the year from a 'date' column.    Example:  Date column: 23-02-2023           ...
Microsoft Lists
SharePoint Online
ganeshsanap's avatar
ganeshsanap
MVP

Jonas_Daragas 

Note: 

  1. Sometimes comma( , ) does not work in formula (it is based on language or regional settings on your site). So in that case use semicolon( ; ) instead of comma( , ). 2. Use correct display names of your columns in the formula.

Documentation: Calculated Field 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.

For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

Jonas_Daragas's avatar
Jonas_Daragas
Copper Contributor
Mar 28, 2023
I don't mean in the formula. I mean the result is showing a , (in your example), mine shows a . (because of my region). So the problem is in the result.
  • ganeshsanap's avatar
    ganeshsanap
    MVP
    Mar 28, 2023

    Jonas_Daragas Try using formula in this format: 

     

    =IF(ISBLANK([Date]),"",TEXT([Date],"yyyy"))

    Output: 

     

    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.

    For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

    • Jonas_Daragas's avatar
      Jonas_Daragas
      Copper Contributor
      Mar 28, 2023
      Syntaxis error
      • ganeshsanap's avatar
        ganeshsanap
        MVP
        Mar 28, 2023

        Jonas_Daragas You have to adjust the formula as per the language of your SharePoint site.

         

        Refer to my above note about using semicolons instead of commas now. Refer documentation link for more information about functions used in calculated column formula.

        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.

        For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs

Resources