Conditional Formats for dates

[Guest]

Hello,

I'm trying to have a report turn a field red if "todays date" exceeds the
date listed in the reports field. Please help.

Thanks,
John

 

[Rick B]

Then put in the condition of <Date()

This will turn it if the entry is less than the current date.

 

[Guest]

Very Helpful, thank you.
One other question if you can help. Now I want the Query that populates the
report to be a little more automated. Right now I have the Expression "IS
NULL OR Between [Enter Start Date] and [Enter End Date]" What I actually want
to do is have the query pull data for "IS NULL OR (start date of 1-1-01) and
(end date of one month past todays date)

Is this possible?

Thanks,
John

 

[Steve Schapel]

John,

Try it like this...
Is Null Or Between #1/01/2001# And DateAdd("m",1,Date())