Discussions

Expand all | Collapse all

WorkdayAdd trouble with my formula field

  • 1.  WorkdayAdd trouble with my formula field

    Posted 09-27-2018 15:23
    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.


  • 2.  RE: WorkdayAdd trouble with my formula field

    Posted 09-27-2018 15:26
    The Factory Order - Order Date is a date field, then why do you need the ToDate function?


  • 3.  RE: WorkdayAdd trouble with my formula field

    Posted 09-27-2018 15:45
    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. 


  • 4.  RE: WorkdayAdd trouble with my formula field

    Posted 09-27-2018 19:02
    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.


  • 5.  RE: WorkdayAdd trouble with my formula field

    Posted 09-27-2018 19:47
    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..?