Need Conditional Formatting Expression Please 1

[Kiernan]

Hey, guys. I need help with a field that I'll want conditional formatting on a form and a report.

Specifically, I have an event that happened with a date. I need the field to format to red if it's been 9 months or more since that date.

For example, I have a field EPR_Closeout and a medium date of 29-Aug-06. Since it's been more than 9 months since that date, I want it to show red so that I know it's coming due (annual).

Can you guys help me out with the expression I need?

Thanks a ton.

 

[Kiernan]

I have another question, related to the first.

I'd like to conditionally format a future date based off the current date. ie: something expires 30-Oct-07, I want it to show red 3 months before the date in the field. The field is M4_Expiration.

Again, thanks in advance!

 

[Remou]

You can use DateAdd and Expression Is:

[tt]Date()>=DateAdd("m",9,[EPR_Closeout])[/tt]

The interval to add can be negative.

 

[Kiernan]

I'll give that a go. Thanks!

 

[Kiernan]

Worked like a champ. Couldn't have asked for more. Thanks again, Remou.