Skip to main content
Question

Formula Numerical , if blank than days until today

  • November 27, 2021
  • 0 replies
  • 74 views
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 calculate how many days until I received my documents in a Formula - Numeric field. The formula is:

ToDays([Permit Received Date] -[Permit Submission Date])

I'm trying to have this fill in the number of days from the permit submission date to the current day [ toady() ] if Permit Received Date is blank. I haven't found the method to communicate "if blank, then x"

Can someone support?

Thank You so much.

------------------------------
Anthony Wong
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------
Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement