Forum Discussion

DanielFuhriman's avatar
DanielFuhriman
Qrew Member
5 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
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
5 years ago
It worked! Thanks for giving me such a positive first experience on this site Mark!