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
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())
)
)
If(
not IsNull([Started]),"N/A",
ToText(([Start])-(Now())
)
)
Try this
If(
not IsNull([Started]),"N/A",
ToText(ToDays(Today() - [Start])))
If(
not IsNull([Started]),"N/A",
ToText(ToDays(Today() - [Start])))