Background colour with a date

[Paul1981]

Hi,

I am using Crystal Reports XI and I would like to change the background colour of my 'called customer' date field yellow when the date is over a month ago.

Can anyone help?

Thanks

Paul

 

[KeertanaCR]

Hi,

Right Click on the field and select HighLight Expert from the menu, There you can add the conditon by clicking new and change the font color and background color to ur required colors

 

[lbass]

Right click on the date->format field->border->color-background->x+2 and enter:

if datediff("d",{table.date},currentdate) > 30 then
crYellow else crNoColor

-LB