Does anybody know a way of showing days past on view (rendering of a page), since the day an item was created.
I need this number for other calculations, to color format some usefull output.
I see a lot of example, mainly telling that [today] / today() can’t be used for that in calculated columns, some work around that require the item to be modified, but that’s not what i want, i like to show, when items are not modified. and people are late to respond i need to show that.
–update– This problem seams a bit more complex then i originally thought. As i wrote i want to see how long it takes before people respond. There’s a status(text) and modified(date) column, once text changes to it should stop counting, and preferably another column starts to counting between status assigned and status closed. (modified date might not be the best indicator for this is the status column, as modified might not always work(people need to have opened it). FYI there is also another column with a closed date, and closed is a status as well, so closed date could be retrieved from it.
Therefore i think client side rendering would not solve this. Yes those scripts work to so show days since, but at some point they should stop counting, i dont think i could do that with client side rendering
So i think i should do some kind of server side powershell script, and schedule it to run each day at 00:01 (not the best option perhaps but right now i dont know other solutions to this).