Formula Numerical , if blank than days until today

Question

Hello,I'm tracking how long it takes on average for me to receive documents from an outsourced department.&nbsp;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------------------------------

markshnier__you · Answer

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------------------------------

Forum Discussion

Formula Numerical , if blank than days until today

1 Reply