Forum Discussion

LB's avatar
LB
Qrew Trainee
2 years ago

Negative duration of days

I am working on a duration field to count the number of days passed from a date that is entered in another field, but it's returning a negative number. 

I'm sure it's something I need to add to the formula but I am not sure

[Date FOC Form Sent]- Today()

------------------------------
Lorrie B
------------------------------

2 Replies

  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew #1 Challenger
    :)  Try reversing
    Today() - [Date FOC Form Sent]

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • LB's avatar
      LB
      Qrew Trainee
      LOL! I knew I was overthinking it! Thank you!

      ------------------------------
      Lorrie
      ------------------------------