Forum Discussion
QuickBaseCoachD
8 years agoQrew Captain
Try this
var date EndDate = IF(not isnull([Pit Backfilled On]),[Pit Backfilled On], Today());
ToDays($EndDate - [Pit Open Date])
I am making use of a formula variable to readability
https://help.quickbase.com/user-assistance/formula_variables.html
var date EndDate = IF(not isnull([Pit Backfilled On]),[Pit Backfilled On], Today());
ToDays($EndDate - [Pit Open Date])
I am making use of a formula variable to readability
https://help.quickbase.com/user-assistance/formula_variables.html