Indicator to show task approaching end date

[Peteupnorth]

I use formulas and graphical indicators to show update status of tasks :
Red : Past the finish date and not complete
Yellow : Past start date with zero%
Maroon : Past start date with some progress
Blue : Completed
Green : Not yet due to start

I would like to add in an indicator to identify tasks that are due to start
within the next 7 days but cannot get any formula to work. Can any one help
with this please. I am using a Number field for the indicators described
above.

 

[TonyK]

Hi Fabio

Try this formula. If you use a Number field then you must have a number as
an output, i.e. "1" or "2". If you use a Text field then you can have, for
example, "Red" or "Green" as the output.

For a Number field:
IIf(DateDiff("d",[Current Date],[Start])<8,1,2)

For a Text field:
IIf(DateDiff("d",[Current Date],[Start])<8,"Red","Green")

Hope this helps.

Kind regards

Tony

 

[Peteupnorth]

Thank you.
That helped me sort it out ! I couldnt recall whether the difference in
dates was in days or hours or minutes - it turns out to be days in this
instance and it makes a great difference where abouts in the formula I put
the condition. The end result was this (amongst 8 other conditions)

IIf([% Complete]=0 And [Finish]<Now()+7,6,IIf([% Complete]<100 And
[Finish]<Now()+7,7

Thank you again

Hi Fabio

Try this formula. If you use a Number field then you must have a number as
an output, i.e. "1" or "2". If you use a Text field then you can have, for
example, "Red" or "Green" as the output.

For a Number field:
IIf(DateDiff("d",[Current Date],[Start])<8,1,2)

For a Text field:
IIf(DateDiff("d",[Current Date],[Start])<8,"Red","Green")

Hope this helps.

Kind regards

Tony
--
TonyK

I use formulas and graphical indicators to show update status of tasks :
Red : Past the finish date and not complete
Yellow : Past start date with zero%
Maroon : Past start date with some progress
Blue : Completed
Green : Not yet due to start

I would like to add in an indicator to identify tasks that are due to start
within the next 7 days but cannot get any formula to work. Can any one help
with this please. I am using a Number field for the indicators described
above.