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.

Up Next
    Ebook Download
    View all
    View all