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


In this article we have seen how to get an Year only from the date time column using calculation field in SharePoint 2013 list.