I have tried using =TEXT(Today,"mm-dd-yyyy hh:mm:ss") but that only returns the 5/5/55 00:00:00, it won't give the time. How do I get both the date and time with a calculated formula?
Unfortunately if you are trying to have this always show the current date and time, this won't work since Calculated Columns are not recalculated on viewing, but only on creation and modification. See this article: http://blog.pentalogic.net/2008/11/truth-about-using-today-in-calculated-columns/
However, if you are just trying to extract the time when calculated then you could switch your formula to:
Sure you can, here are the methods http://office.microsoft.com/en-us/windows-sharepoint-services-help/CH010103260.aspx
I have a list with tasks that all have to be finished within a certain deadline. I wanted the list to show me which deadlines were getting closer or were exceeded. After a long search on the internet I found there was no satisfying solution to make a column using the current date.
However, I found out that when you modify the view of a list, you can put
I made 3 different views of the same list on one page. For all views I edited the
View 1, named: Deadline exceeded:
View 2, named: Deadline < 30 days:
View 3, named: Deadline > 30 days:
Additionally I placed the different webparts in colored tables (red, orange and green).In this way it’s very easy for me to prioritize the different tasks in my task list. .