Discussions

Expand all | Collapse all

Duration formula that doesn't show negative #'s

  • 1.  Duration formula that doesn't show negative #'s

    Posted 20 days ago
    Edited by Daniel Fuhriman 19 days ago
    Hi! 

    I was wondering if there is a way to run a duration formula between two dates, and only have it show the result in days if the answer is >= 0?

    This is what I am using now: [Bid Submission Date]-Today()
    Here is my result


  • 2.  RE: Duration formula that doesn't show negative #'s

    Posted 20 days ago
    no problem,

    If you want to show 0 days, you can use this formula

    Max(Days(0), [Bid Submission Date]-Today())

    if you want to show blank, the n you can use

    IF([Bid Submission Date]-Today() > Days(0), [Bid Submission Date]-Today())


    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    mark.shnier@gmail.com
    ------------------------------



  • 3.  RE: Duration formula that doesn't show negative #'s

    Posted 19 days ago
    Edited by Daniel Fuhriman 19 days ago
    It worked! Thanks for giving me such a positive first experience on this site Mark!