Forum Discussion

testio2's avatar
testio2
Brass Contributor
Apr 17, 2019

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...
  • NabeelSalie's avatar
    NabeelSalie
    Feb 17, 2020

    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)

Resources