Forum Discussion
Solved
Create an 'Age/Days old' column in SharePoint List
Hello. I am using SharePoint Online with a sharepoint list I wanted to create a column which is called 'Age' This would show many days old an item is What I currently have (Please see pic) i...
Hi Norman Young
The Number function of @now (& date fields) returns the value in milliseconds.
The value 86,400,000 represents 1 day in milliseconds
( 1000 x 60 x 60 x 24 )
Yes, by removing the /365 your result will be in days
For month result, you will have have to replace /365 with /30 (this will not be 100% accurate result due different number of days in a month)
Christophe Humbert actually NOW() doesn't resolve the issue of auto-updating calculated columns. It doesn't matter if you write your calculated columns with NOW() or TODAY(), the problem exists that the data becomes incorrect after one day unless you edit the item.
