Formula to Suppress Field Background

[skystar70]

Hi there. I am using Crystal version 9.2 and I am trying to put a yellow background on a particluar field of data and then suppress the backround if the data meets certain criteria.
The field is a datetime field. I want to supress the backround if the datetime field is +/- 30 days from the current date. When I try to create this formula, in the format field - suppress formula for the background option, I get a message that "The formula result must be a number". I have tried all kinds of formulas. Here is one:
{@ProjectEndDate} in Aged0To30Days
Here is the formula for @ProjectEndDate:
If isnull({custom_data.actcompdate}) Then
If isnull({custom_data.acecmpldt}) Then
If isnull({custom_data.planenddate}) Then
DateTimeValue (1900, 01, 01)
Else
{custom_data.planenddate}
Else
{custom_data.acecmpldt}
Else
{custom_data.actcompdate}

Any help would be greatly appreciated.

Thanks,
Skystar

 

[skystar70]

Never mind. I got it. Didn't give myself enough time to figure it out. Here is my formula:

if ({@ProjectEndDate} in Aged0To30Days) or
({@ProjectEndDate} in Next30Days) then yellow
else white

Thanks!
Skystar