Skip to main content
Question

Calculate the number of days between Today and Date Modified

  • July 19, 2018
  • 0 replies
  • 642 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+12
    • LauraThacker
    • Registered
    • July 19, 2018
    Today() - [Date Modified]
    Laura Thacker (IDS) laura@intelligentdbs.com (626) 771 0454
    • KatrinaE
    • Registered
    • February 7, 2019
    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())
    )
    )
    Terms & ConditionsAccessibility statement