WorkdayAdd trouble with my formula field

  • 0
  • 1
  • Question
  • Updated 2 months ago
  • In Progress
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.
Photo of David Brogdon

David Brogdon

  • 366 Points 250 badge 2x thumb

Posted 2 months ago

  • 0
  • 1
The Factory Order - Order Date is a date field, then why do you need the ToDate function?
Photo of David Brogdon

David Brogdon

  • 366 Points 250 badge 2x thumb
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. 
Photo of Lisa

Lisa

  • 210 Points 100 badge 2x thumb
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.
Photo of David Brogdon

David Brogdon

  • 366 Points 250 badge 2x thumb
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..?