How to get date and current time from a Date / Time column in a SharePoint list

Question

I have a column called "Date Submitted" as a date / time in one of the user list in sharepoint 2007. It is always set to date at 12 a.m. and not that I want to display today the date with the current time hh: mm : ss.

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

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

Can this be achieved?

Thanks. edging

Answer 1

try putting = NOW () in the default field in the column properties

Answer 2

In the definition of Date Submitted, is Date and Time Format Date Date only? If so, try changing it to a date and time.

Answer 3

A few ideas to get you started: -

• Can you use the created date instead - will the exact time of record creation always be set?

• When you enter a new item in the calendar list, the current time is used by default - could you make your list from the modified calendar list, and not into the user list?

• I wrote a blog post about how you can use the JavaScript hack to set the default duration for a new calendar entry - you can change this for use with a custom list and set the field for the current time.

  Set default duration for new calendar events

• You can write your own custom field type.

  SharePoint 2007 default user date time fields for current time

  Codeplex - custom date date field

Answer 4

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

Answer 5

= TEXT ([DateFiled Here], "mm / dd / YYYY hh: mm: ss")

Answer 6

Here's how to do what you want:

=TEXT(Today,"mm/dd/YYYY")&" "&TEXT(Now(),"h:mm:ss")