Using Current Date with Filters

[John]

Today

Jim,
The problem with using the Today function in a filter is that once it is
entered, Project sets the date. From then on that filter has that fixed
date.

An alternate approach is to use an interactive filter, but then the user
would have to enter today's date each time the filter is activated and
is sounds like the Michael doesn't want to make users enter a date.

My suggestion is to use a spare date field (e.g. Date1) and customize it
with a formula. The formula is simply, "Now()", which will be updated
with the current date each day. Then use that spare field in the filter.

John
Project MVP

I am using Project 2003 Sp3.
I am trying to filter for certain tasks where Start is less than [Current
Date] or Finish is less than [Current Date].

Currently. I am using the (Select Date) in the Value field. I would like
to
see if I can just use something like [Current Date], so the user would not
have to select the current date manually (I did try to put [Current Date]
in
the value field but it didn't let me).

Is there a better way to do this?

 

[Michael Morgan]

I am using Project 2003 Sp3.
I am trying to filter for certain tasks where Start is less than [Current
Date] or Finish is less than [Current Date].

Currently. I am using the (Select Date) in the Value field. I would like to
see if I can just use something like [Current Date], so the user would not
have to select the current date manually (I did try to put [Current Date] in
the value field but it didn't let me).

Is there a better way to do this?

 

[Jim Spiller]

Today

 

[Jim Spiller]

Ahh, you're right. The Today function is not as fancy as I thought...

Today

Jim,
The problem with using the Today function in a filter is that once it is
entered, Project sets the date. From then on that filter has that fixed
date.

An alternate approach is to use an interactive filter, but then the user
would have to enter today's date each time the filter is activated and
is sounds like the Michael doesn't want to make users enter a date.

My suggestion is to use a spare date field (e.g. Date1) and customize it
with a formula. The formula is simply, "Now()", which will be updated
with the current date each day. Then use that spare field in the filter.

John
Project MVP

message

I am using Project 2003 Sp3.
I am trying to filter for certain tasks where Start is less than
[Current
Date] or Finish is less than [Current Date].

Currently. I am using the (Select Date) in the Value field. I would
like
to
see if I can just use something like [Current Date], so the user would
not
have to select the current date manually (I did try to put [Current
Date]
in
the value field but it didn't let me).

Is there a better way to do this?

 

[Jack Dahlgren MVP]

Ahh, you're right. The Today function is not as fancy as I thought...

"Today" needs to be updated. It is so yesterday.

-Jack Dahlgren

 

[Michael Morgan]

John,

I just got back to this post and found to be true what you guys are saying.
Before the post I was able to do what you suggested by customizing a date
field. I was hoping to avoid using a customized field and inflating the size
of the schedules, but I think this is the best option.

Maybe tomorrow they will update today?

Today

Jim,
The problem with using the Today function in a filter is that once it is
entered, Project sets the date. From then on that filter has that fixed
date.

An alternate approach is to use an interactive filter, but then the user
would have to enter today's date each time the filter is activated and
is sounds like the Michael doesn't want to make users enter a date.

My suggestion is to use a spare date field (e.g. Date1) and customize it
with a formula. The formula is simply, "Now()", which will be updated
with the current date each day. Then use that spare field in the filter.

John
Project MVP

I am using Project 2003 Sp3.
I am trying to filter for certain tasks where Start is less than [Current
Date] or Finish is less than [Current Date].

Currently. I am using the (Select Date) in the Value field. I would like
to
see if I can just use something like [Current Date], so the user would not
have to select the current date manually (I did try to put [Current Date]
in
the value field but it didn't let me).

Is there a better way to do this?

 

[John]

John,

I just got back to this post and found to be true what you guys are saying.
Before the post I was able to do what you suggested by customizing a date
field. I was hoping to avoid using a customized field and inflating the size
of the schedules, but I think this is the best option.

Maybe tomorrow they will update today?

Michael,
The addition of one customized field is not going to noticeably impact
the size of your schedules. In comparison, just doing a straight "save"
each time you edit does more to inflate the file size than adding a
single custom field. That's why I always use "Save As".

Then again, Today should have been updated yesterday.

John
Project MVP

Today

Jim,
The problem with using the Today function in a filter is that once it is
entered, Project sets the date. From then on that filter has that fixed
date.

An alternate approach is to use an interactive filter, but then the user
would have to enter today's date each time the filter is activated and
is sounds like the Michael doesn't want to make users enter a date.

My suggestion is to use a spare date field (e.g. Date1) and customize it
with a formula. The formula is simply, "Now()", which will be updated
with the current date each day. Then use that spare field in the filter.

John
Project MVP

message
I am using Project 2003 Sp3.
I am trying to filter for certain tasks where Start is less than
[Current
Date] or Finish is less than [Current Date].

Currently. I am using the (Select Date) in the Value field. I would
like
to
see if I can just use something like [Current Date], so the user would
not
have to select the current date manually (I did try to put [Current
Date]
in
the value field but it didn't let me).

Is there a better way to do this?