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!!
Any help would be appreciated!!
Forum Discussion
19 Replies
- Today() - [Date Modified]
- Did you try my formula as a Formula numeric field type?
- If you want a numeric field for the # of days , it would be
ToDays(Today() - ToDate([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.
- I'm trying to get the difference between todays date and the expected start date of a project but if the project has been started already, I want the value to be NA. I have a text field and it's not letting me put the "-", if I do a numeric, it won't let me do the value NA
If(
not IsNull([Started]),"N/A",
ToText(([Start])-(Now())
)
)- Try this
If(
not IsNull([Started]),"N/A",
ToText(ToDays(Today() - [Start]))) - I'm getting an error, "-" can't be applied to dates and times
- Can you tell me what type of field [Start] is?
