I am trying to update the date in a column to show Today's date and automatically update it every day in SharePoint 2013.

Can someone help? How to achieve this?

A front-end or client-side approach would be best.

  • You need a trigger to update, do you want a back-end (.Net) trigger or a front-end? (user display a View (and code update fields) Commented Dec 1, 2015 at 20:50
  • Could you please advise on the front-end approach? How would I edit the View?
    – joe 222
    Commented Dec 2, 2015 at 0:10

1 Answer 1


The Today() function inside a Calculated Column Formula is correct,
But only if the Item (or formula itself) was updated TODAY

Much written about:

So your use-case requires a trigger to update the Items daily, either a workflow,

OR Client Side code:

Create unique number with ListItem [ID] and [Today] age in Calculated Column Formula

Explains how to do it from a Calculated Column in a view; but the encapsulated JavaScript code can be used in any SharePoint page. CSR in a ListView the more obvious.


  • Why should the formula be updated? I think Today() would work even without updating since it is just JavaScript getting rendered by the browser, no?
    – Akhoy
    Commented Dec 2, 2015 at 13:08
  • The Today() function inside a Calculated Column Formula. That is the SharePoint Today() function Commented Dec 2, 2015 at 13:10
  • Ah! I thought Today() was a JS function. Oops... my bad.
    – Akhoy
    Commented Dec 2, 2015 at 13:12
  • 1
    Note: there is no SharePoint documentation on this Today() function; it does exist since 2013 Commented Dec 2, 2015 at 13:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.