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 D...
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!