Forum Discussion
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 ...
Syntaxis error
Jonas_Daragas
A little bit late 😉, but perhaps useful for others.
Try:
=IF(ISBLANK([Date]);"";TEXT([Date];"yyyy"))
As ganeshsanap said, formula per language but also per regional setting.