Problem with TextColor & Date Calculation

[Steven Cappiello]

I have two fields that are date fields. "Review C" & "Review D"

I have an unstored calc that gives todays date: "Today"

I have another field "Next Review" that is an unstored calculation resulting in a date based on the 2 review fields (it figures out which of the first two date fields is next on the calendar).

I have another unstored calculated date field "Next Review colored", that hopefully will displays which dates from the "Next Review" field occur in the next 180 days by coloring them red. Dates after 180 days should be in black.

I tried two ways, neither of which worked:

first:

Case( Next Review - 180 < Today;

TextColor(Next Review; RGB (255; 0; 0));

Next Review)

and also:

Case( GetasNumber(Next Review) - 180 < Getasnumber(Today);

TextColor(Next Review; RGB (255; 0; 0));

Next Review)

Both give me black text results.. none show up in red. Even though based on the math, some should certainly show up in red.

[-Queue-]

Try using GetAsText(Next Review) in your TextColor calc or make the result text and not date. AFAIK, TextColor does not work with dates.

[Steven Cappiello]

Queue, you rock.. this isn't the first time you've come through for me. Thanks!

Can I paypal you a beer or something ?? -)

[-Queue-]

Possibly, if I could remember where the heck my paypal info is...