Discussions

 View Only
  • 1.  Formula Numerical , if blank than days until today

    Posted 11-27-2021 09:11
    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
    ------------------------------


  • 2.  RE: Formula Numerical , if blank than days until today

    Posted 11-27-2021 11:55
    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
    ------------------------------