Filter: today plus # of days

T

tmann

Hi,

I'm trying to create a filter that shows me tasks that are schedule to
*start* in the next 4 weeks. I've tried to create the following
filter:

Field Name: Start
Test: Is less than or equal to
Value(s): today+28
AND
Field Name: Start
Test: Is greater than or equal to
Value(s): today

Project doesn't seem to like "today+28" -- so I'm obviously not doing
this right. Any thoughts on how to make this work?

Thanks in advance for your help!
Tommy
 
P

Perfect Reign

Hi,

I'm trying to create a filter that shows me tasks that are schedule to
*start* in the next 4 weeks. I've tried to create the following
filter:

Just curious - have you had any luck with this yet?

This would be a useful feature for me. I've been printing tasks out in
this format using the print dialog box, but it would be nice to have such
a filter.

TIA

--
kai
www.perfectreign.com

kai:/> format c:
Error: The DOS concept of formatting disk media is screwed.
If you want to create a filesystem use "mkfs". To format a floppy, use
"fdformat /dev/fd0" and then "mkfs.minix /dev/fd0".
 
J

John

Perfect Reign said:
Just curious - have you had any luck with this yet?

This would be a useful feature for me. I've been printing tasks out in
this format using the print dialog box, but it would be nice to have such
a filter.

TIA

Perfect Reign,
Are you asking a question here? There is so much other "stuff" in the
post, we can't tell what you need.

John
Project MVP
 
T

tmann

Yes, I finally figured out how to do this.
1) create 2 customized date fields (Tools -> Customize -> Fields)
2) Formula for Date1 should be Now()
3) Formula for Date2 should be Now()+28
4) Create a filter where Start is <= [Date2] AND Finish is >= [Date1]

Thats it.
Tommy
 
P

Perfect Reign

Perfect Reign,
Are you asking a question here? There is so much other "stuff" in the
post, we can't tell what you need.

Um, yes. I was curious if he had any luck with the creation of a filter
that showed him the tasks that are scheduled to "start" in the next four
weeks.

I aplogozie for excessive posting, if that is what I'm guilty of.



--
kai
www.perfectreign.com

kai:/> format c:
Error: The DOS concept of formatting disk media is screwed.
If you want to create a filesystem use "mkfs". To format a floppy, use
"fdformat /dev/fd0" and then "mkfs.minix /dev/fd0".
 
P

Perfect Reign

Yes, I finally figured out how to do this.
1) create 2 customized date fields (Tools -> Customize -> Fields)
2) Formula for Date1 should be Now()
3) Formula for Date2 should be Now()+28
4) Create a filter where Start is <= [Date2] AND Finish is >= [Date1]


Oh, very cool! That's ingenous.

Thanks.


--
kai
www.perfectreign.com

kai:/> format c:
Error: The DOS concept of formatting disk media is screwed.
If you want to create a filesystem use "mkfs". To format a floppy, use
"fdformat /dev/fd0" and then "mkfs.minix /dev/fd0".
 

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