2 week look ahead

S

swell estimator

I've been asked to prepare a schedule with a 2 to 3 week-look ahead.

Please point me to the information that describes how to do this.

Thank you in advance for your help, Swell.
 
J

Jack Dahlgren MVP

From the "Project" menu select "Filtered For" and then the "Date Range"
filter.
Set the date values appropriately for current date and 2 or 3 weeks ahead.

-Jack Dahlgren
 
M

Maurice Birchler

You can set up a couple for task custom date fields:
LastSunday =
DateAdd("d",1-Weekday(DateValue(format(Now(),"DD/MM/YYYY")),1),DateValue(format(Now(),"DD/MM/YYYY")))
SundayWeek =
DateAdd("d",15-Weekday(DateValue(format(Now(),"DD/MM/YYYY")),1),DateValue(format(Now(),"DD/MM/YYYY")))

You might need to change the formulate for US date format and weekday from
Sunday = 1st day of week - This is because My world is not U.S.

Now all you need to do is create a Filter that selects tasks with date
between these two calculated custome fields.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top