In this post we will discuss how to extract Year and Month from the created date column in SharePoint 2013. Here we will extract through calculated column and store in two separate columns.
Also check out:
-
Go to the list settings and then click on Create column to add a new column. Give the column name and chose the column type as calculated column. Then in the formula write like below:
=TEXT([Created],"yyyy")
it should be shown like below:
The above formula will return the formula as a single line text, Now if you want to return as integer then you can write the formula like below:
=YEAR(Created)
Similarly
if you want to store month then follow the above step and write the formula like below:
=Text(Created, "MMMM") : This will return the full month name
=Text(Created, "MMM") : This will return first 3 letters of the month name
=Text(Created, "MM") : This will return integer month
If you want to return the value as an integer then you can write the formula like below:
=MONTH(Created)
Now if you will check the output will come like below: