2week look ahead

as far as I know, there is no "Data Date Line" in MSP (i don’t know the latest versions)

Hi Alex,

In the past I have used a Date Range filter (or an adaptation) to achieve this. However, this shows the filtered tasks with their complete durations, regardless of the fact only a portion of the task happens during the timeframe specified in the Date Range filter.

For a quick view this is sometimes all you need, but you can also use the timescale option when printing to narrow down the field of view, so it just prints the two week window.

Regards,

Darren

Say we want the look-ahead to be 3 weeks ahead of the Status Date.
You can do the same thing similar for the Current Date.
Use a spare Date field, Date1, to store the Status Date.
Tools, Customise Fields, then Formula and Status Date is in Function,
Project.
Use another spare Date field, Date2, to store the [Status Date] +21

Once you have the boundaries of your date range stored in fields you can
make a Filter which is similar to the built-in Date Range Filter but which
gets its data from the fields instead of user input.
Make a Filter called "AA 3 Week Look-ahead".
Project, Filtered For, More Filters, New.
Filter like this:
Tasks whose Start is less than or equal to [Status Date] +21
And
Tasks whose Finish is greater than or equal to [Status Date]

Thanks Trevor,

could you please elaborate on this
"Use a spare Date field, Date1, to store the Status Date.
Tools, Customise Fields, then Formula and Status Date is in Function,Project."

is it Function===>Project===>ProjDateValue(expression)?

I’m not getting it right.


Cheers

Insert/show the Date1 field.
Right-Click on the heading of the Date1 column.
Click Customise Fields on the menu.
First Rename the Date1 field.
Call it "S Date" or similar, but you can’t use "Status Date" because that is a reserved name.
Then write the formula which just consists of one function, which is the Status Date.
You can just type it or get it from the list of functions with the function button.
[Status Date] is the last one under Project, Date.