Conditional Formatting a date..

[Plasma]

Hello,

I have a table that has expiration dates for certain products, what I would like to do is set up conditional formatting in the Report where the date shows up in red if the expiration date is within 30 days from expiring. I've searched but only can find what I'm looking for in Excel, ie.

=DATE(YEAR(TODAY()),MONTH(TODAY())+2,DAY(TODAY()))

But that doesn't work in Access.

Is this possible?

thanks..

[Plasma]

Figured this out.. If I add conditional formatting

between DateAdd("m",-1,Date()) and DateAdd("m",1,Date())

it will work.

also need to know how to flag if something is greater than the expiration date. I tried setting it to

greater than Date(), but it will flag everything regardless of date.

[alansidman]

Try less than Date(). You are looking for expiration dates that have occurred before today if I understand your issue.

Alan