Defining Null Value 1

[pineisland99]

I'm working on a formula which will add a 1 everytime there is a date in my field. Basically if my field (f422#Close_date) has a date, then a 1 is added.
If there is no date(empty) then 0.

How do you signify a null or empty set.. i tried this but it does not work:
if {f422#Close_date}) <> "" then
1
else
0

This did not work either:
if {f422#Close_date}) <> NULL then
1
else
0

Appreciate the help

 

[Madawc]

Try if IsNull ({f422#Close_date})

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[pineisland99]

Beautiful:

I changed my formula to:
if isNull({f422#Close_date}) then
0
else
1

this worked,

thanks