Conditional formatting behaving badly...

[Nightowl4933]

I have a report that shows a calculated date field (a future expiry date), either 'x' years from a specific date or from a defined date.

I'm trying to highlight the calculated date where it is 12 months before today, using the following Conditional Formatting rule:

Condition 1: Field Value Is - greater than or equal to - Now()-365

The bizarre thing is only some of the dates are highlighted, as shown in the attached screenshot.

Any ideas, please?

 

[Ranman256]

you don't use date math that way in access,
use:
DateAdd(...) or DateDiff(...)

DateAdd("m",-12,date())
DateAdd("d",-365,date())

 

[Nightowl4933]

you don't use date math that way in access,
use:
DateAdd(...) or DateDiff(...)

DateAdd("m",-12,date())
DateAdd("d",-365,date())

Sorted, thank you