.Net & SharePoint '07

Technical blog for .Net and all SharePoint 2007 related Information

About the author

Me(Prince) and my wife are B.E in I.T & C.S.E respectively.  I a certified MCPD: Web from 2007 Dec. I am Intrestes in Web Application, MOSS, EPM, etc.
Now working with Deira International School, as IT Application & Help Manager. I have started my career as "Software Developer" @  REACH Sewn Technologies and Consulting Pvt. Ltd, Bangalore India from Oct 2004 to Feb 2006, then as "Web & Intranet Developer" @ Fosroc International Ltd, Dubai from April 2006 to Sep 2009.
You can catch me on mail@jpy-tech.com or mail@princepy.com. Or on 00971 - 50 - 4284530 

Google Translate

Tag cloud

Calendar

<<  May 2012  >>
MoTuWeThFrSaSu
30123456
78910111213
14151617181920
21222324252627
28293031123
45678910

View posts in large calendar

RecentComments

Comment RSS

Google Your Location


[Today] in Calculated Columns

“Calculated columns cannot contain volatile functions like Today and Me”>

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.

Categories: MOSS | WSS
Posted by admin on Sunday, March 15, 2009 11:00 PM
Permalink | Comments (0) | Post RSSRSS comment feed