I have added Year column in SharePoint list and I want the default value to be current year.
To do this in default value of a column, select calculate value and put below formula in Text box
=TEXT(Today,"YYYY")
Similarly to select current month in moth column put below formula in Text box:
=TEXT(Today,"mmmm")
Hope this helps!!!!
To do this in default value of a column, select calculate value and put below formula in Text box
=TEXT(Today,"YYYY")
Similarly to select current month in moth column put below formula in Text box:
=TEXT(Today,"mmmm")
Hope this helps!!!!
No comments:
Post a Comment