http://www.endusersharepoint.com/STP/ SharePoint QA en Fri, 29 May 2009 01:37:53 +0000 http://www.endusersharepoint.com/STP/topic/calculate-column-adding-today-timestamp-mmddyy-hhmm#post-320 Mon, 28 Jul 2008 13:41:04 +0000 rcrabb 320@http://www.endusersharepoint.com/STP/ <p>there are ways of showing the time for a calculated column, my question is, what column are you calculating the change off? Created already stores date/time as does Modified ..</p> <p>BUT, for example, you can calculate a date/time stamp off Modified like</p> <p>=TEXT(WEEKDAY(Modified),"ddd")&#38;" "&#38;TEXT(Modified,"h:mm")</p> <p>It will print “Tue 5:03” for example </p> http://www.endusersharepoint.com/STP/topic/calculate-column-adding-today-timestamp-mmddyy-hhmm#post-303 Mon, 28 Jul 2008 08:29:36 +0000 AutoSponge 303@http://www.endusersharepoint.com/STP/ <p>TODAY only produces the date. In Excel, another function, NOW(), uses Date/Time. If you tried to use Date/Time with TODAY() it will probably always read noon. Is that what you want? </p> http://www.endusersharepoint.com/STP/topic/calculate-column-adding-today-timestamp-mmddyy-hhmm#post-299 Mon, 28 Jul 2008 03:51:16 +0000 colm 299@http://www.endusersharepoint.com/STP/ <p>Is there any way that I can use the calculate column field to generate a timestamp (one that atores the Current DATE and TIME ). I followed the examples of Dessie Lunsford (http://www.endusersharepoint.com/?p=410) but his TODAY function only displays the timestamp in date format, not Date and Time. </p> <p>All help is appreciated!<br /> Colm. </p>