Comparing Finish Date to Now() not resulting in expected conclusion in formula

A

anovak

I have a stoplight indicator using the following formula:

Switch([% Complete]=100,"0",
[Finish]>now(),"1",
[Finish]=now(),"2",
[Finish]<now(),3)

I also have graphical indicators as follows:
"0" check mark
"1" green
"2" yellow
"3" red

The third one (yellow) doesn't seem to "fire" eventhough I have a
situation where the finish date is today's date. Is there some
function I need to use to make sure the date AND time isn't taken into
consideration?

Thanks,
Andy Novak
University of North Texas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with the RAG Status in Project 0
Checking for "NA" in Baseline Finish column (or any column) using formula 1
Building stoplight indicators using CURRENT DATE 1
enterprise custom field for overdue tasks 11
Getting project to recognize the current date for my formulas 4
Enterprise Duration 1 vs. (Local) Duration 1 3
** Customer Formula for a Custom Field ** 1
RAG status - formula required 4

Top