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()
Question
Duration formula that doesn't show negative #'s
This topic has been closed for replies.
+24no 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
------------------------------
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
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.