Forum Discussion

Qrew Member

3 years ago

Formula Numerical , if blank than days until today

Hello, I'm tracking how long it takes on average for me to receive documents from an outsourced department. I currently have a submission date, and a received date. I have a formula to calcu...

Formulas and functions

MarkShnier__You

Qrew Legend

3 years ago

np,

var date EndDate = IF(IsNull([Permit Received Date]),Today(), [Permit Received Date]);

ToDays($EndDate - [Permit Submission Date])

I like to use formula variables in my formuals to make them stupid simple to read.

https://help.quickbase.com/user-assistance/formula_variables.html

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------