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

listsharepoint

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

Best Answer

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