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) – Danny '365CSI' Engelman Dec 1 '15 at 20:50
  • Could you please advise on the front-end approach? How would I edit the View? – joe 222 Dec 2 '15 at 0:10

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.


| improve this answer | |
  • 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 Dec 2 '15 at 13:08
  • The Today() function inside a Calculated Column Formula. That is the SharePoint Today() function – Danny '365CSI' Engelman Dec 2 '15 at 13:10
  • Ah! I thought Today() was a JS function. Oops... my bad. – Akhoy Dec 2 '15 at 13:12
  • 1
    Note: there is no SharePoint documentation on this Today() function; it does exist since 2013 – Danny '365CSI' Engelman Dec 2 '15 at 13:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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