In Excel, you can use Today() to call today’s date into a calculation. For whatever reason, Microsoft hasn’t implemented this in MS Project.
If you want to set up a filter that checks to see if a milestone is due in the next two weeks, you would typically have to use the Status Date of the project. Using the status date is a perfectly reasonable thing to do. However, there are times when you want to use today’s date. One example of this is when using Master and Sub project plans, it can be a pain to go into each sub-plan to set the status date.
To use today’s date in a filter, you will have to set up a Custom Field (for instance, Date1) with the calculation set to either:
[Current date]
Now()
Now that you have this custom field, you can call it into filters like this one used to show critical milestones planned for the next two weeks. This uses an additional text field based on the Today function to show how many weeks until a milestone is due.
The entire sequence to generate this filter is:
