Help Date formula for Flag field

[Steve]

Using 2002 MSProject Prof. I am trying to enter a formula in the flag1
field to show a "Yes" for any tasks with a Start Date on or after 10/01/06.
But it does not work. What I'm I missing?

IIf([Start]>"10/01/06",Yes,No)

Steve

 

[JackD]

Try the following:
IIf([Start]>datevalue("10/01/06"),Yes,No)

I think that the problem is that the date you have given is being
interpreted as text. Using the datevalue function ensures it is interpreted
as a date.

-Jack

 

[Steve]

Thank you Jack. Works perfect, I'm using with a filter to grap all tasks
within a defined year without summmary task and sorting on Locations
(outline field) and start date. For me, it gives a clearer overall picture
of who's where and why in relation to the overall project. It also
highlighted some areas of excess travel because other qualified resources
were available within the same location working other projects in difference
phases.

Steve

Try the following:
IIf([Start]>datevalue("10/01/06"),Yes,No)

I think that the problem is that the date you have given is being
interpreted as text. Using the datevalue function ensures it is interpreted
as a date.

-Jack

Using 2002 MSProject Prof. I am trying to enter a formula in the flag1
field to show a "Yes" for any tasks with a Start Date on or after 10/01/06.
But it does not work. What I'm I missing?

IIf([Start]>"10/01/06",Yes,No)

Steve

 

[JackD]

Glad I could help. Good luck with it!

-Jack

Thank you Jack. Works perfect, I'm using with a filter to grap all tasks
within a defined year without summmary task and sorting on Locations
(outline field) and start date. For me, it gives a clearer overall picture
of who's where and why in relation to the overall project. It also
highlighted some areas of excess travel because other qualified resources
were available within the same location working other projects in difference
phases.

Steve

Try the following:
IIf([Start]>datevalue("10/01/06"),Yes,No)

I think that the problem is that the date you have given is being
interpreted as text. Using the datevalue function ensures it is interpreted
as a date.

-Jack

Using 2002 MSProject Prof. I am trying to enter a formula in the flag1
field to show a "Yes" for any tasks with a Start Date on or after 10/01/06.
But it does not work. What I'm I missing?

IIf([Start]>"10/01/06",Yes,No)

Steve