In a sharepoint 2007 list, Is there a way to initialize a field with the current timestamp? I've tried setting the datetime field to Today, and it just fills in the date not the time. I've tried to use a calculated field but i'm running into formula problems. ThanksPeter schenk

Hi, You can use Date and Time field here. Under the default option select Todays date and in Date and Time format select date and time. I hope this will help you out.Thanks, Rahul Rashu

Thanks Rashu, Rahul. but when I did that I get the current date, but the time part of the timestamp is not filled in. I found a work around using the modified field, but would like to know if there is a better way. Peter schenk

Hi pete2059, You can achieve it by the following screenshot. Thanks, Jack

Thanks Jack, That works great on a date field and will populate the date part of a timestamp correctly, but the time portion of a timestamp is set to midnight (all zeros). Is there a way to get a current timestamp that will get not only the current date but the current time as well? thanks Peter schenk

Create yourself a column called "Time" and make it a "Calculated (based on other columns)" in your formula add, =TEXT([Modified],"hh:mm:ss") If you want to base it on the last modified time, otherwise you can replace with [Created] and drop the :ss if you don't want the seconds included. Paul Turner http://redmanta.co.uk/blog Twitter: @RedMantaUK MCTS:WSS,MOSS,2010 MCITP:2010. Please remember to click "Propose As Answer" if a post solves your problem or "Vote As Helpful" if it was useful.

Thanks Paul, That worksPeter schenk