Another Conditional formatting question

  • Thread starter Thread starter Steph
  • Start date Start date
S

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!
 
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!
Click to expand...

As Condition1, try using:
Expression is
[ThisControlName] < DateAdd("yyyy",-1,Date())
 
Thanks Fred, but for some reason, it is still not working!!

fredg said:
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!
Click to expand...

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
.
Click to expand...
 
Back
Top