How to include NULL date

[syncdba]

Hi,
I have created a report in CRXI with a record selection formula which is as follows
(
if cdate({?Start_Date}) <> cdate(1970,1,1) then
{LAST_UPLD_DT} >= ({?Start_Date})
else if cdate({?Start_date}) = cdate(1970,1,1) then
{LAST_UPLD_DT} = currentdate
else if isnull({LAST_UPLD_DT}) then {LAST_UPLD_DT}=cdate(0)
)

The LAST_UPLD_DT has null dates also like
LAST_UPLD_DATE Last_Week
0
0
6/15/2007 1
0
6/16/2007 1
If I use the above formula in record selection it shows only 2 records only(No Null Values)
6/15/2007 1
6/16/2007 1

I tried to update the formula to show NULL values but nothing is working.
Any help. Thanks in Advance.

 

[Turkbear]

Hi,
In Crystal,you need to test for NULL first ...Just resequence your If.Then..Else statements.



To Paraphrase:"The Help you get is proportional to the Help you give.."