Date in RED

[Tore]

I have a Date field that I have named "DoItBefore". And when the date I have put there is history then I want it to show in red. Now, it seems that isn't possible unless I do a trick. I show another field which is a calculation field instead, with this:

If ( DoItBefore < Get ( CurrentDate ) and Status = "Open";TextColor ( DoItBefore ; RGB ( 250 ; 0 ; 0 ) ); TextColor ( DoItBefore ; RGB ( 0 ; 0 ; 0 ) ))

Anybody knows if it can be done directly on the Date field?

:shower:

[Paul de Halle]

I'm afraid the TextColor command is only supported on text fields. Along with all the Text format commands.

[Tore]

Thanks, OK that's what I thought. My solution above works, but I just don't like all those "work around" solutions.

[Nightmarcher]

i don't know if this will help, but i've recentley come up with a solution to blank out the date (day) fields when applicable by changing the color of the text via a calc field. calcs could be cleaner value wise, but you get the idea. hope this helps

oh crap, nevermind, i just re-read what you put down and it's basically what i did. sorry!

-N

cal_colors.zip

Edited December 3, 2005 by Guest