October 23, 200520 yr 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:
October 23, 200520 yr I'm afraid the TextColor command is only supported on text fields. Along with all the Text format commands.
October 24, 200520 yr Author Thanks, OK that's what I thought. My solution above works, but I just don't like all those "work around" solutions.
December 3, 200520 yr Newbies 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, 200520 yr by Guest
Create an account or sign in to comment