Calculate the number of days between Today and Date Modified
I need a formula to calculate from todays date to the time a project was last modified. Any help would be appreciated!!
Forum Discussion
Today() - [Date Modified]
If you want a numeric field for the # of days , it would be
ToDays(Today() - ToDate([Date Modified]))
ToDays(Today() - ToDate([Date Modified]))