Status With Color

[Dr. Evil]

Hello All!

Sample File Attached. I am having troubles getting this calculation to work properly.

I need to mark Assignment with:

Repetition #2 (Purple) if Assignment Status is “Working” and past due.

Repetition #1 (Gray) if Assignment Status is “Complete” and past due.

Calculation works except for the “Working” past due section.

Even if status field is marked "Working" calc results repetition #1 (Grey)

I do not know how to set the criteria for the Case function in this calc to look for days past AND status.

Please help, thank you for your interest.

Sincerely,

StatusByColor.fp7.zip

[MarkWilson]

Case(

date_deadline - Get(CurrentDate) ≥ 7; GetRepetition(Home::colors; 5);

date_deadline - Get(CurrentDate) ≥ 3; GetRepetition(Home::colors; 4);

date_deadline - Get(CurrentDate) ≥ 0; GetRepetition(Home::colors; 3);

date_deadline - Get(CurrentDate) < 0 [color:red]and txt_status = "Working"; GetRepetition(Home::colors; 2);

date_deadline - Get(CurrentDate) < 0; GetRepetition(Home::colors; 1)

)

[Dr. Evil]

:

Ok, the change from "Complete" to "Working" was a duh on my part. Oops, :

BUT!!! What is the difference between "&" and "And"?:

This calc dose NOT work with the "&". Whoa.

Please, if you have a moment, explain.

THANK YOU for your help!

[The Shadow]

& appends two strings together:

  "ab" & "cd" -> "abcd"

"and" is a boolean operator:

  True and False -> False

  True and True -> True