Forum Discussion
Solved
Date Range Filter
I am trying to use the date range filter in ms project and I put in my dates for let's say a 1 month timeframe but some of the tasks that come back when I run the filter are showing to be outside of ...
- sirsleep29,
The task in your screen shot has a finish date that is "greater than or equal to" today's date. And it's start date is "less than or equal to" 8/11/23. So yup, it's in the date range.
I have always felt the structure of the Date Range filter is confusing, but, it does do what it says.
John
It is most confusing because the second part asks "and before", which makes you think that it is within the one month that you are entering but it isn't true then.
sirsleep29,
As I said, confusing. But hopefully I answered your question.
John
As I said, confusing. But hopefully I answered your question.
John
- You're welcome.
- Thank you for your help Isaac
Hi Aaron,
I would search the internet for the subject. There are plenty of articles on the date range filters and lookahead filters on the internet such as the one below:
https://www.plannersplace.com/blog/how-to-create-a-rolling-date-lookahead-filter-in-microsoft-project
I hope this helps.
IsmetPS. Prompt messages in the Date Range filter are confusing.
- Aaron,
Date filters aren't that difficult but they can be tricky. I contacted a colleague who does a lot of training on Project custom field formulas. I asked if he would jump into this thread and help out. I'll check back later to see if you get the help you need.
John - John...lol....I had a 20 yr layoff from having to use Project so it is a learning curve for me....been back in it for about 4 months. I have done filters recently but never a date filter. Would you happen to have a good link to a place that would teach me how to create a date filter. I want to do a lookahead 6 month and 1 yr calendar. Thank You, Aaron
- sirsleep29,
You're welcome and thanks for the feedback. I've worked with Project since 1997 or thereabouts, so a couple of years anyway.
John John, I appreciate your help....how long have you been working with MS Project?
