Go to your SharePoint list.
Figure 1: Office
Here I have an Year from DOB column. Click Create Column from the top ribbon.
Figure 2: Ribbon
The following popup will appear.
Figure 3: Appear
Enter column name (Year) and select calculated column.
Figure 4: Create Column
Paste the following code to Formula field.
=CONCATENATE(YEAR(DOB)) Here, I have an year from DOB date time column.
![]()
Figure 5: Time Column
Click Ok button. The results will be as in the following screenshot:
![]()
Figure 6: Result
Summary
In this article we have seen how to get an Year only from the date time column using calculation field in SharePoint 2013 list.