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]
Here is what I get:
The expression Today() on the left hand side of the operator "-" is of type datewhile the expression [Date Modified] on the right hand side is of type date/time. The operator "-" cannot be used with these types of expressions.
The expression Today() on the left hand side of the operator "-" is of type datewhile the expression [Date Modified] on the right hand side is of type date/time. The operator "-" cannot be used with these types of expressions.