I am getting number of days between Created & Now in SharePoint 2010 list using calculated column by below mentioned formula.
=IF(ISERROR(DATEDIF(NOW(),Created,"d")),DATEDIF(Created,NOW(),"d"))
It gets me the correct value.
But the problem is that the counts are not updating on regular basis.
e.g.
Imagine that i had created item in list before 5 days & if i create calculated column using above formula than it will give me correct count (5) but if i go to list on next day than it is showing me the same count. It is not updating to 6.
Can you please help me on this?