Forum Discussion

AlexBennett3's avatar
AlexBennett3
Qrew Trainee
5 years ago

Null Date Field

Hey Everyone, I wanted to see if I could get some Formula advice. I have a formula that takes a start date and adds duration: WeekdayAdd([Sub Start Date], ToNumber([Gas Pipe Total Duration])-1) ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
try this


IF(Nz(ToNumber([Gas Pipe Total Duration])<>0,
WeekdayAdd([Sub Start Date], ToNumber([Gas Pipe Total Duration])-1))

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • AlexBennett3's avatar
    AlexBennett3
    Qrew Trainee
    5 years ago
    Hey Mark, I'm getting an error that is saying 'expecting bool, but found number'

    ------------------------------
    Alex Bennett
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      Can you post the whole error message you get when you save, including the part where it repeats back and underlines the problem?

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • AlexBennett3's avatar
        AlexBennett3
        Qrew Trainee
        5 years ago
        Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets.


        IF(Nz(ToNumber([Gas Pipe Total Duration])<>0,
        WeekdayAdd([Sub Start Date], ToNumber([Gas Pipe Total Duration])-1))  



        ------------------------------
        Alex Bennett
        ------------------------------