Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2003
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Different Filter (2000)

    I am trying to show a filter to show a graphic for all active tasks during the next two weeks. I know how to create an IIF to see what tasks start in the next 2 weeks and which end in the next to weeks... but if the project starts before this period and ends after its still active but i dont know how to add that to the statement. suggestions?

    Thanks

  2. #2
    Silver Lounger GARYPSWANSON's Avatar
    Join Date
    Aug 2001
    Location
    Frederick, Maryland, USA
    Posts
    1,788
    Thanks
    0
    Thanked 2 Times in 2 Posts

    Re: Different Filter (2000)

    Good Morning,

    You lost me with your statement, "but if the project starts before this period and ends after its still active but i dont know how to add that to the statement. "

    You say you are trying to show all active tasks for the next two weeks. How do you define when a task is active? Do you mean you want to show all tasks that have either Baseline Starts or Planned Starts in the next two weeks as well as ongoing tasks that will not be complete in the next two weeks? Percent Complete not equal to zero or 100? Any Resources to check for work?

    You could do something similar to the following filter for in progress tasks (See attachment)
    Attached Files Attached Files
    Regards,

    Gary
    (It's been a while!)

  3. #3
    3 Star Lounger
    Join Date
    Jun 2003
    Posts
    238
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Different Filter (2000)

    Thanks Gary, that really helped. Maybe you can help with my newest post, but either way Thanks a lot. I was able to use that model to create many filters.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •