Share via

Tasks completed in last 2 weeks

Anonymous
2012-04-26T17:08:09+00:00

Greetings!

I am trying to configure a Task filter to display only tasks 'Completed' in last 2 weeks (calendar days) (i.e. 10 business days).

I tried tweaking my earlier filter of Completed Last Week that I had setup :

Custom Start (([Current Date]-Weekday([Current Date],2)-1)-5_) , Custom Finish ([Current Date]-Weekday([Current Date],2)+1)

I changed 5 in Custom start to 10. 

Unfortunately, this did not work (getting error in filter setup).

Any advise on simpler way of getting this configured?

Best Regards,

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

John Project 49,705 Reputation points Volunteer Moderator
2012-04-28T17:44:42+00:00

stct80,

I assume you customized a flag field with the formula I gave you. If you then filter on that flag field, it will provide a dynamic filter because the formula contains the Current Date field which changes each day.

Hope this helps.

John

Was this answer helpful?

0 comments

8 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. John Project 49,705 Reputation points Volunteer Moderator
    2012-05-15T20:17:44+00:00

    stct80,

    Wow, been a while. Nonetheless you're welcome and thanks for the feedback. Please mark this post as being answered.

    John

    Was this answer helpful?

    0 comments
  2. Anonymous
    2012-05-15T19:31:07+00:00

    Perfect, John! Thank you!

    Was this answer helpful?

    0 comments
  3. Anonymous
    2012-04-28T16:38:20+00:00

    Thank you John! This works fine. I added a Custom Flag field for filtering the last 2 weeks completion.

    I have a question on this report. Will this custom Flag field value change dynamically every day and every week (by detecting the system date)? or I have to change any value every time I pull the report for the Last 2 weeks of completion?

    Please advise.

    Best Regards,

    Was this answer helpful?

    0 comments
  4. John Project 49,705 Reputation points Volunteer Moderator
    2012-04-26T22:37:30+00:00

    stct80,

    Try the following formula:

    IIf([% Complete]=100 And 0<=ProjDateDiff([Actual Finish],[Current Date]) And Projdatediff([Actual Finish],[Current Date])<=4800,"yes","no")

    John

    Was this answer helpful?

    0 comments