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.
Asked
Active
Viewed 1,410 times
1
Ganesh Sanap - MVP
- 44,918
- 21
- 30
- 61
joe 222
- 31
- 6
-
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 01 '15 at 20:50
-
Could you please advise on the front-end approach? How would I edit the View? – joe 222 Dec 02 '15 at 00:10
1 Answers
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.
Related:
Danny '365CSI' Engelman
- 21,176
- 7
- 35
- 79
-
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 02 '15 at 13:08
-
The Today() function inside a Calculated Column Formula. That is the SharePoint Today() function – Danny '365CSI' Engelman Dec 02 '15 at 13:10
-
-
1Note: there is no SharePoint documentation on this Today() function; it does exist since 2013 – Danny '365CSI' Engelman Dec 02 '15 at 13:14