In SharePoint [Today] returns 12:00 PM. How do I get current time?
Trying this as value for column "=Today+TIME(Hour(Today);Minute(Today)-10;0)".
This is for new items and it's to set default value for a DateTime column.
+1
A:
As far as I am aware you can't use times with Today in a calculated column. Also if you aren't already aware, Today does not update automatically, only when you edit the list item.
JavaScript is the most common solution to this, although it's a little difficult to know what the options are without the full details. If you re-edit your question with exactly what you would like to do we can help further.
Alex Angas
2009-06-29 11:53:38
I've solved it with javascript. But thought that there should be a more SharePoint properly way.This is for new items and it's to set default value for a DateTime column.
walming
2009-06-29 12:53:18
Afraid not, calculated columns aren't as powerful as we'd like...
Alex Angas
2009-06-29 14:19:20
Accepts this as the answer, as it appears to be the only solution.
walming
2009-07-06 06:06:07