Skip to main content
Question

Calculate the number of days between Today and Date Modified

  • Jul 19, 2018 6:21 PM UTC
  • 0 replies
  • 671 views

I need a formula to calculate from todays date to the time a project was last modified.
Any help would be appreciated!!
This topic has been closed for replies.

Forum|alt.badge.img+14
  • Qrew Corporal
  • Jul 19, 2018 6:24 PM UTC
Today() - [Date Modified]

  • Qrew Cadet
  • Feb 7, 2019 8:57 PM UTC
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())
)
)