Viewing 3 posts - 1 through 4 (of 4 total)
Many thanks Lutz, your solution works great.
Andre your solution nearly works but Tasks 6 and 7 are shown as green and not null.
April 1, 2012 at 8:47 am
#1467427
LutzM (4/1/2012)Shouldn't be Task4 show Amber then? (It's "between" amber and green)
LutzM (4/1/2012)
No, it needs to take the colour above as it hasn't got to the amber colour yet.
What I want...
April 1, 2012 at 8:18 am
#1467422
LutzM (4/1/2012)Why should Task2 return Amber?Why NULL for Task 6 and 7?
Why NULL for Task 6 and 7?
Task 2 is amber as it is one day old, so between red and amber.
Tasks 6 and 7 are...
April 1, 2012 at 7:58 am
#1467418