Skip to main content
Question

WorkdayAdd trouble with my formula field

  • September 27, 2018
  • 0 replies
  • 22 views
I am looking for help with my formula. It is in a formula date field

WorkdayAdd(ToWorkDate(ToDate("[Factory Order - Order Date]")), 91)

QB is telling me that it needs a date ("expected date") even though I know the field is a date field that I am referrencing. 

Can someone help me understand why this isnt working?

Thank you.
    This topic has been closed for replies.

    • SuryaExpert
    • Quickbase Alumni
    • September 27, 2018
    The Factory Order - Order Date is a date field, then why do you need the ToDate function?
    • DavidBrogdon
    • Author
    • Quickbase Alumni
    • September 27, 2018
    Thanks for your reply. Okay, I will give you that one, I pulled this formula off the help section and plugged it in. 

    Regardless, I tried it with a hard-coded date like "12/12/2001" as well and I get the same error. I also tried removing the ToDate and am still getting the error. 
    • LisaSell1
    • Quickbase Alumni
    • September 27, 2018
    I made a Formula-Date field named 'workdatetest' , and a date field :
     
    ToDate(WorkdayAdd(ToWorkDate([Factory Order - Order Date]),91))

    The formula editor shows a warning, but it does function correctly.
    • DavidBrogdon
    • Author
    • Quickbase Alumni
    • September 27, 2018
    Thanks, Lisa. I can't seem to get rid of that warning for some reason. 
    It is working though, as you mentioned. Must be a QB error..?
    Terms & ConditionsAccessibility statement