Get An Year From The Date Time Column In SharePoint

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.