Skip to main content
Question

Negative duration of days

Forum|alt.badge.img+8
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
------------------------------
    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24
    :)  Try reversing
    Today() - [Date FOC Form Sent]

    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    Mark Shnier. Your Quickbase Coach
    Terms & ConditionsAccessibility statement