Jump to content

How to turn a date field red?


Totes

This topic is 6322 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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 by Guest
Link to comment
Share on other sites

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 by Guest
Fixed Calc Error
Link to comment
Share on other sites

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::B:: the date field is now showing a ?mark..I think I screwed something up.

James

Edited by Guest
Link to comment
Share on other sites

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

Link to comment
Share on other sites

This topic is 6322 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.