Hi,

I am trying to use the follwing conditional format on a report date field.

"Expression Is">DateAdd("M",6,Date())

The objective is to show in red all dates that are 6 months and older from today.

For some reason all dates come up red... even dates entered yesterday..

Can anyone help?

Thanks.

Fen How

Try using fieldvalue?? instead of expression

Thanks,

So do I choose field value IS ?"Equal To" ">DateAdd("M",6,Date())

?

Thanks

Fen How

Uhm, no... you want to color red all those with a date before 6 months ago

=>

Use fieldvalue less than DateAdd("M",6,Date())

FieldValue < DateAdd("m",-6,Date())