Forum Discussion
KnoppGrunt
Apr 17, 2024Copper Contributor
Status indicators disappear after every check-in
Hello, I created a simple status indicator on my plan : A deadline in "Date3" field; An estimated finish date in "Finish1". If Date3>=Finish1; green If Date3<Finish1; red If Date3 is "NC";...
- Apr 19, 2024
Ignacio_Martin
Apr 19, 2024Iron Contributor
- KnoppGruntApr 19, 2024Copper ContributorSomehow... it works! I tried it with no image at all (not even the blank square), works just fine too.
In the end it seems that comparing a field date to value "NC" is not a valid test for a date field.
Many thanks for your time, it helps me a great deal.
Tom- Ignacio_MartinApr 19, 2024Iron Contributor
Hello Tom
Project takes the value NC(Non Communiqué)=NA(Not Available) in date fields with no value, as we already know.
However, Project consider that when comparing dates, NA is superior to any date (?)
To detect date=NA I choose the condition: date>31/12/2149, knowing that there will not be any task date entered by the user greater than that maximum date that Project allows, as indicated by the forced error message that is displayed below.
I'm glad I could help you.
Ignacio