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)
Hello testio2,
Is there anyway to have this automatic column that just shows a number of how old the item is?
Not using out of the box functionality. Consider using a Flow to update the Age column on a daily basis.
I hope this helps.
Norm