How to get Date and current time from the Date/Time column in SharePoint Custom list

Question

I have column called "Date Submitted" as Date/time in one of the Custom list in sharepoint 2007. it always set to today's date and 12AM time instead of that I want to display today's date with current time hh:mm:ss.

I tried creating calculated column TestDate and formula is : =TEXT(([Date Submitted]),"mm dd yyyy h:MM:SS")

result is 04 28 2010 0:00:00 I wanted to be 04/28/2010 10:50:34

Is it possible to achive this?

Thank you kanta

Answer 1

A few ideas to get you started :-

• Can you use the Created date instead - it will always be set to the exact time the record was created?

• When entering a new item on the Calendar list it defaults to the current time - could you make your list from a modified Calendar list rather than the Custom list?

• I've written a blog post about how you can use a JavaScript hack to set the default duration for a new calendar record - you could modify this to use with a Custom list and to set the field to the current time.

  Setting a default duration for new calendar events

• You could write your own custom field type

  SharePoint 2007 Custom Date Time Field to default the time to the current time

  Codeplex - custom date time field

Answer 2

In the definition of Date Submitted, is the Date and Time Format currently Date Only? If so, try changing it to Date & Time.

Answer 3

For something like this, I ended up creating a custom action which is called from a workflow.