Date Formats confusing formula

[walshut]

Here we go,

I have a formula that highlights a field if it meets two conditions. I created this formula under the format editor. The first condition is for the cost to be greater than zero, the next condition, that the date be greater than or equal to the current date. Look below for the formula.

My problem is this, the formula I have created does not distinguish the date fields that have nothing entered into them from the dates that are <= to today. It considers these null values as being after the current date. How can I develop this formula to not include null values for my date fields?

Formula so far:

if {RES.MONTH_MAINT} < 0
and {RES.WARR_END} <= CurrentDate
then crRed
else crBlack

 

[rogar]

IF IsNull({RES.WARR_END} then
<color you want if date is null>
ELSE
(if {RES.MONTH_MAINT} < 0
and {RES.WARR_END} <= CurrentDate
then crRed
else crBlack)

 

[dgillz]

Or, under file options, make sure the &quot;convert null field value to default&quot; option is checked. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com