How do I set the VALUE field to Defining Custom Filter for Current

B

Brad Harris

MSP2k7
When creating a filter in a view, like for checking late tasks, how do I
set the VALUE field up to be the current day? The field name is FINISH, the
test is IS GREATER OR EQUAL TO, The value needs to be CURRENT DAY, but
current day is not an option. Does anyone know
 
J

Jackson T. Cole

The exact details escape me but you will need to create a custom date
field, built with a formula. The trick is how to build the formula, and right
this second, I can't give the detailed description! I did this same thing for
STATUS DATE a while back in another life, in order to ship it over to PWA and
see who was updating projects regularly.

Hope this helps (a littel) ...
 
J

Jackson T. Cole

Curiosity got the better of me, and I went into Project to experiment.
Below is the formula to populate a custom date field with the current date:

ProjDateValue([Current Date])

"ProjDateValue" is found in the "Function" list under "date/Time, and
"Current Date" is found in "Fields" under "Project".

Ensure that the renamed field is NOT "Current Date"!

Hope this helps(more!) ...
 
B

Brad Harris

Thanks Jackson, I will try this.
Will the PM have to open and close and save the project for the custom field
to be populated?

Jackson T. Cole said:
Curiosity got the better of me, and I went into Project to experiment.
Below is the formula to populate a custom date field with the current date:

ProjDateValue([Current Date])

"ProjDateValue" is found in the "Function" list under "date/Time, and
"Current Date" is found in "Fields" under "Project".

Ensure that the renamed field is NOT "Current Date"!

Hope this helps(more!) ...

Jackson T. Cole said:
The exact details escape me but you will need to create a custom date
field, built with a formula. The trick is how to build the formula, and right
this second, I can't give the detailed description! I did this same thing for
STATUS DATE a while back in another life, in order to ship it over to PWA and
see who was updating projects regularly.

Hope this helps (a littel) ...
Click to expand...
Click to expand...
 
J

Jackson T. Cole

Yes, open, calculate, save, and I think that is a FORCED calculate.
Formula fields are not automatically calculated like dates, etc.

If you push this custom field to Enterprise, remember that the last date
of publish is the date that will show up in PWA.

JTC

Brad Harris said:
Thanks Jackson, I will try this.
Will the PM have to open and close and save the project for the custom field
to be populated?

Jackson T. Cole said:
Curiosity got the better of me, and I went into Project to experiment.
Below is the formula to populate a custom date field with the current date:

ProjDateValue([Current Date])

"ProjDateValue" is found in the "Function" list under "date/Time, and
"Current Date" is found in "Fields" under "Project".

Ensure that the renamed field is NOT "Current Date"!

Hope this helps(more!) ...

Jackson T. Cole said:
The exact details escape me but you will need to create a custom date
field, built with a formula. The trick is how to build the formula, and right
this second, I can't give the detailed description! I did this same thing for
STATUS DATE a while back in another life, in order to ship it over to PWA and
see who was updating projects regularly.

Hope this helps (a littel) ...

:

MSP2k7
When creating a filter in a view, like for checking late tasks, how do I
set the VALUE field up to be the current day? The field name is FINISH, the
test is IS GREATER OR EQUAL TO, The value needs to be CURRENT DAY, but
current day is not an option. Does anyone know
Click to expand...
Click to expand...
Click to expand...
 
B

Brad Harris

Thanks, Works like a champ!

Jackson T. Cole said:
Yes, open, calculate, save, and I think that is a FORCED calculate.
Formula fields are not automatically calculated like dates, etc.

If you push this custom field to Enterprise, remember that the last date
of publish is the date that will show up in PWA.

JTC

Brad Harris said:
Thanks Jackson, I will try this.
Will the PM have to open and close and save the project for the custom field
to be populated?

Jackson T. Cole said:
Curiosity got the better of me, and I went into Project to experiment.
Below is the formula to populate a custom date field with the current date:

ProjDateValue([Current Date])

"ProjDateValue" is found in the "Function" list under "date/Time, and
"Current Date" is found in "Fields" under "Project".

Ensure that the renamed field is NOT "Current Date"!

Hope this helps(more!) ...

:

The exact details escape me but you will need to create a custom date
field, built with a formula. The trick is how to build the formula, and right
this second, I can't give the detailed description! I did this same thing for
STATUS DATE a while back in another life, in order to ship it over to PWA and
see who was updating projects regularly.

Hope this helps (a littel) ...

:

MSP2k7
When creating a filter in a view, like for checking late tasks, how do I
set the VALUE field up to be the current day? The field name is FINISH, the
test is IS GREATER OR EQUAL TO, The value needs to be CURRENT DAY, but
current day is not an option. Does anyone know
Click to expand...
Click to expand...
Click to expand...
 
Top