AnsweredAssumed Answered

Conditional format of field based on todays date and a future date

Question asked by pademo57 on Feb 7, 2011
Latest reply on Feb 10, 2011 by pademo57

Title

Conditional format of field based on todays date and a future date

Post

Yes, if you can't tell from the title, I am a newbie.  Here is my problem:

We have a record which shows a date, for example,  Due_Date = March-31-2011.

I have a list that comes up every day with all these Due Dates.

I would like to have the field turn Yellow if I compare the Due Date to today's date and there is less than 30 days between them.

I would also like the field to turn Red if the Due Date and today's date is less than 10 days between them.

For the life of me, I can't figure out how to do this, any and all help greatly appreciated!!!

Outcomes