can't get field color to change correctly w/formula

[inncoggnitto]

i am trying to get a field to stand out in a report when the data is null. i am using

if isnull({TASK.TASK_END_DATE}) then crGreen else crPurple

as a test. the field bg does turn purple when there is data but does not turn green when it is null just no color. i have checked the data and it is definitel null. if i use not isnull then the green works but the nulls do not turn purple.

am i missing something.

 

[synapsevampire]

I'm guessing that the field appears null, but really isn't:

Test with a formula that contains just:

if isnull({TASK.TASK_END_DATE})
then
"Null"
else
"Not Null"

Try changing to something like:

if isnull({TASK.TASK_END_DATE})
or
{TASK.TASK_END_DATE} < currentdate - 10000
then crGreen else crPurple

-k

 

[inncoggnitto]

field is definitely null. it is a date field and oracle will not allow anything but a date in it, not even a space, that can get into text fields. also using an app called TOAD, (tool for oracle application developers) that shows a {null} for null values.

tried your suggestions the first won't work, cr requires a number in the formula results, the second works the same as mine, no color change for the null fields.