Get A Month From The Date Time Column In SharePoint 2013 List

Here are the steps to get a month from Date Time column In SharePoint 2013 List:

Go to your SharePoint list.

SharePoint list

Here I have got a month from DOB column. Click Create Column from the top ribbon.

click on create column

The following popup will appear.

select type of column

Enter column name (Month) and select calculated column.

Enter column name

Paste the following code to Formula field.

=TEXT(DOB,"mmmm") Here I have got a month from DOB date time column.


create column

Click Ok button. The results will be as in the following screenshot:

Click Ok

Get a month in number:

Go to list settings, then click Month under Columns menu.

Click Month

Change the formula by the following.

=TEXT(DOB,"mm"). Click Ok button. The results will be as in the following screenshot:

Click Ok button

Get a month in text:

Change the formula by the following in Month column.

=TEXT(DOB,"mmm"). Click Ok button. The results will be shown as in the following screenshot:

Change the formula

The results will be as in the following screenshot:

results

Summary

In this article we saw how to get a month only from the date time column using calculation field in SharePoint 2013 list.

Up Next
    Ebook Download
    View all
    Learn
    View all