I really hate to bother everyone with such a newbie question, but this thing is getting the best of me and I am about to just give up on it.

I have a date field and I want the date shown to turn red if it is within a 7day window, so the viewer can see that the date is approaching soon.

I have tried the Date <= get(currentdate)+7 and change textcolor calculation but I get nothing.

What am I doing wrong?

Can the textcolor be used on a date field?

Thanks

James

Edited December 5, 200619 yr by Guest

Can text color be used in a date field.. yes

Lets say you want it to go red if the date in the field "date" is within 7 days of today (remember, it has to be an unstored calculation, result date).

Case( Get(CurrentDate) + 7 >= date ; TextColor( yourDateField ; RGB( 200 ; 0 ; 0 ) ;

yourDateField )

Edited December 5, 200619 yr by Guest
Fixed Calc Error

Thank you for replying to my post.

I am trying but I still have nothing good to report.

I get an error of: this function cannont be found and it highlights

TextColorAdd

I took the Add part out and it took it, however the color did not change.

I have the field set as an unstored calculation returning as a date.

What am I missing?

Update::: the date field is now showing a ?mark..I think I screwed something up.

James

Edited December 5, 200619 yr by Guest

Sorry, its just Text Color

Still no luck...as soon as I set the calculation the date field suddenly becomes an unmodifiable field?

I give up, this one has me thinking about drinking for a living

... I think you may be misunderstanding.

But... for color to work, you were right, calc does have to be text, otherwise it should at least show the date... anyway, see the attached.

tempo.zip

Oh, I think I see...I was attempting to turn the "Date" field itself red.

The "Date" field itself cannot be changed to red, a calculation of the field has to be shown in another field and that field will display the calculation of the "Date" Field in red...is that correct.

James

If you want the calculation to be unstored yes... And in your case, it has to be unstored for it to work.

Thank you very much, I just learned in a few minutes what I was attempting to glean from 3 books.

Thanks again,

James

These forums are good for that

Not that i'm saying you shouldn't read..