Need Help With Conditional Formatting a field based on Date Range

[simmka]

Hey All!

I'm working on setting up some conditional formatting on a field that displays due dates. I've figured out how to use conditional formatting to change the text color to orange by this: Self ≥ Get(CurrentDate) - 6. So the date in the field turns orange if the due date is between today and 6 days before the due date (At least I think that's how it's working, Hope!) I also want to:

Have the due date text in the field turn yellow if the due date in the field being formatted is between 7-14 days before the due date
and
Have the text in the due date field turn green if the due date in the field is 15-30 days before the due date.

I'm sure it's an easy one but I'm still green behind the ears .

Thanks!

[doughemi]

Use the same calculations, but put the 30 days condition first:

Self ≥ Get(CurrentDate) - 30 //green
Self ≥ Get(CurrentDate) - 14 //yellow
Self ≥ Get(CurrentDate) - 6 //orange

The conditional result will always reflect the last true condition.

[simmka]

I'm not sure that your suggestion is working. Not sure where I'm going wrong here...Are the calculations correct for what I'm trying to do?

[doughemi]

It works fine for me. If I enter 10/7/12 in the field, the text is green. If i enter 10/17/12, the text is yellow, and if I enter 10/27/12, the text is orange.

The three calculations, as shown, should be in the Conditional Formatting dialog for the due date field. Use the Add button to insert the second and third conditions. All 3 check boxes next to the calculations should be checked.

[Helimanick]

I assume when you say "Due Date" you mean the date in which something is due. So the "Due Date" would be in the future correct? If this is the case then you just need to invert the calculations, I took the liberty of adding the calculations for anything that is greater than 30 days green and Due that day or before Red:

Self ≥ Get(CurrentDate) + 30 //Green Greater than 30 days till due
Self ≤ Get(CurrentDate) + 30 //Green 30 to 15 days till due
Self ≤ Get(CurrentDate) + 14 //Yellow 14 to 7 days till due
Self ≤ Get(CurrentDate) + 6 //Orange 6 to 1 days till due
Self ≤ Get(CurrentDate) //Red due date is today or before meaning it is late

You can modify these as you see fit I just think that it should be red if today is the due date or if it is late.

[doughemi]

I think you're right, Nick. I got crossed up deciding which "due date" was really "current date".

[simmka]

Thank you both, Doug and Nick, very much for your help!

Nick, I'm going to get on implementing your suggestion and see where it takes me but it looks like exactly what I'm asking about!