Negative duration of days

Question

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
------------------------------

markshnier__you · Answer

:)&nbsp; Try reversingToday() - [Date FOC Form Sent]------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------

lb · Answer

LOL! I knew I was overthinking it! Thank you!------------------------------Lorrie------------------------------

Forum Discussion

Negative duration of days

2 Replies