WorkdayAdd trouble with my formula field

Question

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.

suryaexpert · Answer

The Factory Order - Order Date is a date field, then why do you need the ToDate function?

davidbrogdon · Answer

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 · Answer

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 · Answer

Thanks, Lisa. I can't seem to get rid of that warning for some reason.&nbsp;It is working though, as you mentioned. Must be a QB error..?

Forum Discussion

WorkdayAdd trouble with my formula field

Related Content

Formula Assistance

Formula Query with custom key

Formula Url Buttons

Formula Date Field

Date Field Formula