When you try to create a calculated column in sharepoint and use [Today] or [Me] in the formula, it will throw an error message, "Calculated columns cannot contain volatile functions like Today and Me."
You can solve the above issue by following the below steps:
1) Create a dummy column with name "Today". Data type can be anything.
2) Create a new calculated column with name whatever u want(for ex.,"TodaysDate").In the formula select the column "Today".(i.e. Formula should be "=[Today]").
3) Specify the data type of the above column as "Date and Time".
4) Go to the column you created first(i.e. Today)in the list settings and click on it. Click on the button "Delete".
5) Add the calculated column you created("TodaysDate") to the view and you can see the current date displayed there.
2 comments:
Excellent....Works perfectly....Your solution is the simplest I have found on net. Others spoke about Javascripts which was a tedious workaround and load on the servers. Thank you
Thanks dude. Perfectly working. Saved lot of my time to me. Great boss.
Post a Comment