Hi Guys,
Thanks for visiting my blog .
While creating Columns in Custom List many of us have seen the Calculated Column .
I will describe the calculated column for Month and year .
Thanks for visiting my blog .
While creating Columns in Custom List many of us have seen the Calculated Column .
I will describe the calculated column for Month and year .
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")
he 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 above :
No comments :
Post a Comment