Another Conditional formatting question

[Steph]

Hi all, date box, I want it to be red when it is older than a year.

I have this set in my CF condition:

Field value is Greater Than Now()-365 (red,bold)

Well, it is red bold anyways. when i change the date to something LESS then
a year old, it flashes normal quickly, but then goes back to red/bold.

Thanks in advance!

 

[fredg]

Hi all, date box, I want it to be red when it is older than a year.

I have this set in my CF condition:

Field value is Greater Than Now()-365 (red,bold)

Well, it is red bold anyways. when i change the date to something LESS then
a year old, it flashes normal quickly, but then goes back to red/bold.

Thanks in advance!

As Condition1, try using:
Expression is
[ThisControlName] < DateAdd("yyyy",-1,Date())

 

[Steph]

Thanks Fred, but for some reason, it is still not working!!

Hi all, date box, I want it to be red when it is older than a year.

I have this set in my CF condition:

Field value is Greater Than Now()-365 (red,bold)

Well, it is red bold anyways. when i change the date to something LESS then
a year old, it flashes normal quickly, but then goes back to red/bold.

Thanks in advance!

As Condition1, try using:
Expression is
[ThisControlName] < DateAdd("yyyy",-1,Date())

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.