I am trying to create a formula for length of time it takes to correct an item, I would like answer in days.
Date corrected - Date Found,
If Date corrected is blank, then todays date - date problem found.
Question
Formula
This topic has been closed for replies.
+24np,
I will first us a formula variable to calculate the end date to use.
var date EndDate = IF(not isnull([Date corrected]), [Date corrected], Today());
[Date Corrected] - $EndDate)
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
I will first us a formula variable to calculate the end date to use.
var date EndDate = IF(not isnull([Date corrected]), [Date corrected], Today());
[Date Corrected] - $EndDate)
------------------------------
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.