Sharepoint 2013 Custom List Calculate difference between Today and Column Value

Question

I'm attempting to use update a Column [Days Since Last Contact] by calculating the different between =TODAY() and a Column [Date of Last Contact].

I've been trying to use [Day Since Last Contact] as a calculated column, but the list doesn't update this column unless the item has been edited.

The goal is to have the Days Since column update every time someone loads the page. Any idea how to go about this? I can't see to find a way to attach javascript to the list for this purpose.

score 0 · Answer 1 · edited Apr 13 '17 at 12:41

0

Calculated fields are not updated until item itself is updated, please check this question:

calculated field - formula for ageing

edited Apr 13 '17 at 12:41

Community

1

answered Nov 19 '15 at 21:16

Prakash

666
4
19

score 0 · Accepted Answer · edited Apr 13 '17 at 12:41

0

The other answer refers to (outdated) 2011 knowledge

See the 2015 posts:

edited Apr 13 '17 at 12:41

Community

1

answered Nov 20 '15 at 08:03

Danny '365CSI' Engelman

21,176
7
35
79

I have used img onload in views at other places, never thought about calculated columns. Thanks! – Prakash Nov 20 '15 at 09:07
Be aware of some minor drawbacks: http://www.viewmaster365.com/#/How – Danny '365CSI' Engelman Nov 20 '15 at 09:37

Sharepoint 2013 Custom List Calculate difference between Today and Column Value

2 Answers2

Linked