Conditional formatting, expression needed

rbrule

Registered User.
Local time
Today, 11:30
Joined
Jan 13, 2004
Messages
108
Hello,
I have a date field in my form that I would like to have the date change color sixty days prior to the date entered. Can someone give me the expression to use in conditional formatting? For example: If the date is 9/30/05, I would like it to change color on 8/2/05.

Thanks
 
Date() + 60 >= [DateField]
 
Thank you RichO, with some tweeking by adding another date field into the mix it seems to work fine.
 

Users who are viewing this thread

Back
Top Bottom