Column calculated value to get the current date time?

Question

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?

Answer 1

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: =TEXT([Modified],"mm-dd-yyyy hh:mm:ss")

Answer 2

you can also Use Now() instead of Today()

=TEXT(Now(),"mm-dd-yyyy hh:mm")

a sample for date diff

=IF(NOW()<=[End Date], 
DATEDIF(NOW(),[End Date],"d"), 
DATEDIF([End Date],NOW() ,"d") * -1)

Answer 3

Sure you can, here are the methods http://office.microsoft.com/en-us/windows-sharepoint-services-help/CH010103260.aspx

Answer 4

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 [today] in the filter section. This allows you to base the view of your list on the current date. This date will automatically be kept current. (I have a Dutch version of SharePoint, so I hope I guessed the used terms right ;) ).

I made 3 different views of the same list on one page. For all views I edited the list view and checked the box which says only show items if under the tab filter ;

View 1, named: Deadline exceeded:

'Only show if'

'deadline' column

'smaller than'

[today]

---

View 2, named: Deadline < 30 days:

'Only show if'

'deadline' column

'bigger than'

[Today]

and

'Only show if'

'deadline' column

'smaller than'

[Today]+30

---

View 3, named: Deadline > 30 days:

'Only show if'

'deadline' column

'bigger than'

[Today]+30

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. .

Answer 5

The formula to add for only the date is =TEXT(TODAY(),"mm/dd/yyyy"). Make sure the outcome is a single line text.