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
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