This topic contains 0 replies, has 0 voices, and was last updated by kmullervy 6 years, 8 months ago.
-
Posts
-
kmullervy- Contributions: 0
- Level 1
- ☆
We are trying to find a formula to help us display how many business days a work order has been open. We want the count to start when the work order is released and stop counting when the quantity equals built. We currently are using a transaction search and we have this formula but it keeps counting even when the work order is completed.
FLOOR((trunc({today})-trunc({appliedtotransaction.datecreated}))/7)*5 + mod(trunc({today})-trunc({appliedtotransaction.datecreated}),7) – case when to_number(to_char({today},'D')) < to_number(to_char({appliedtotransaction.datecreate d},'D')) then 2 else 0 end
This is a cached copy. Click here to see the original post.
You must be logged in to reply to this topic.