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


i have column called "date submitted" date/time in 1 of custom list in sharepoint 2007. set today's date , 12am time instead of want display today's date current time hh:mm:ss.

i tried creating calculated column testdate , formula : =text(([date submitted]),"mm dd yyyy h:mm:ss")

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

is possible achive this?

thank kanta

try put =now() in default value field in column properties


Comments

Popular posts from this blog

javascript - Enclosure Memory Copies -

php - Replacing tags in braces, even nested tags, with regex -