Can I get the current date in sharepoint 2010?

Question

I want to save the current date as a column that I have, and then compare it with the date that the user has saved.

Can I get the current date in sharepoint 2010?

Answer 1

I wrote an article on our company’s blog, which outlines various methods of using [Today] in this context, as well as a small reference on why [Today] is not available in the calculated columns:

Warning: this also contains recommendations for our own product.

How to use [Today] in the sharepoint list

Here are the basic methods:

• Javascript Use the content editor web part.
• Designer Create a custom view in SharePoint Designer.
• Code Create your own field type from scratch.
• SharePoint Highlighter : Our Own Solution

Answer 2

You can use [Today] as a filter in views. For example, for a task list, you can filter expired tasks by setting the filter "DueDate <[Today]".

Answer 3

Did you know: Computed fields DO accept = Today () then select the date type as Date.
Tested and working: you can use the Today () function in the DATEDIF function. Then select the output type of the formula as expected, for example, you can use the number if the expected result is “D” for several days. http://office.microsoft.com/en-us/help/datedif-function-HA001160981.aspx

Answer 4

You cannot save the current date. You can use the current date to filter query results.