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

try to put =NOW() in the default value field in the column properties

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.