Forum Discussion

DanielFuhriman's avatar
DanielFuhriman
Qrew Member
6 years ago

Duration formula that doesn't show negative #'s

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
Formulas and functions
  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    6 years 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
    ------------------------------
    • DanielFuhriman's avatar
      DanielFuhriman
      Qrew Member
      6 years ago
      It worked! Thanks for giving me such a positive first experience on this site Mark!