I'm trying to figure out how to make report filters use business days (M - F) and not calendar days. Our WF schedule is already set up for work hours to only be M - F.
For example, I want to show tasks with due dates within the next 2 days, but the report doesn't take weekends into account. So if I have a filter of Due Date Between $$TODAY+2d and $$TODAY+1d , it works fine, until we get to the end of the week. On Thursday, it won't show any tasks due the following Monday. It counts the weekend even though our company WF doesn't list Sat and Sun as work days.
Is there a workaround for this?
Solved! Go to Solution.
This is a longstanding source of irritation for me and my team. Workfront (surprisingly) doesn't support this, but I invite you to upvote my idea to add "workdays" as a date-based wildcard for filtering: https://one.workfront.com/s/idea/0870z000000PSbwAAG/detail
This is a longstanding source of irritation for me and my team. Workfront (surprisingly) doesn't support this, but I invite you to upvote my idea to add "workdays" as a date-based wildcard for filtering: https://one.workfront.com/s/idea/0870z000000PSbwAAG/detail
Yes! I just figured this out:
WEEKDAYDIFF(date2, date1)
Here is a link to some other helpful formulas:
Hi Kelly - I love this! Can you please share your report and/or all of the filters you are using on this report?
Thank you!
Views
Replies
Total Likes
Views
Likes
Replies
Views
Likes
Replies