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
Post a Comment