Re: Formula Numerical , if blank than days until today

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)
[email protected]
------------------------------