Row conditional formatting based on a specific date range

[THarrison]

Good morning,

I am new to Access and I'm having trouble getting my rows of an Access 2007 report to conditionally format how I want them to. Here's the situation:

I have a report that has about 12 columns of data, one of them being a next deadline field, titled "NEXT DEADLINE".

I have already formatted the specific "NEXT DEADLINE" field to highlight red if the deadline is within 30 days from a certain date, which works fine. However, when I try to conditionally format the other columns, such as "CUSTOMER NAME" in the report to highlight red based on the date in the NEXT DEADLINE field being within a certain range, such as within 30 days, nothing happens.

I have looked online and found suggestions of expressions to try such as [NEXT DEADLINE]<30, Eval([NEXT DEADLINE] Between "3/25/2015" And "4/25/2015"), and other combinations of these conditions, and none of them seem to work.

Does anyone have any advice or possible solutions? Any advice is greatly appreciated.

[pbaldy]

Try

[NEXT DEADLINE]<Date()+30

[THarrison]

Pbaldy, I assume I am supposed to add in the date that I want to add 30 days to (i.e. [NEXT DEADLINE]<Date(3/25/2015)+30), correct? If so, Access returned the error "The expression you entered has a function containing the wrong number of arguments".

[orange]

THarrison,
Date() is an Access intrinsic function. It represents today's Date.

Paul's suggestion
[NEXT DEADLINE]<Date()+30
is code for [NEXT DEADLINE] is less than 30 days from today Date()
Date()+30 is today + 30 days

[pbaldy]

And the function is a function with no arguments, so nothing goes inside the parentheses, it's just Date(). There's also Time() for the current time and Now() which returns the current date and time together.

[THarrison]

Thank you for the clarification, Orange and Paul. I tried the expression [NEXT DEADLINE]<Date()+30, however, it is not returning the format that I set if the value is true, even if the deadline is within 30 days. Any other ideas? Do I need to format the [NEXT DEADLINE] field a certain way in order for the conditional formatting to work in the other fields? Currently, it is formatted as m/dd/yyyy.

[THarrison]

Please disregard my last message. I had the background set to "Transparent". When I changed that to "Normal", the formatting took effect. Thank you both for your help!!!

[pbaldy]

Happy to help and welcome to the site by the way!