[RESOLVED]check for date null value doesn't work. help.

[waely]

hi,
I have formula that checks for two date fields and displays the earlier one.
I tried these tow formulas:

if date1 < date2 OR date1 = date2 then date1
else if isnull(date1) then date2
else if isnull(date2) then date1
----------------------------------------------
if date1 < date2 then date1
Else date2
----------------------------------------------
these formulas work if none of the dates is Null.
the data is coming from Stored Proc and when I run it in the analyser I get Null values for some fields.

any suggestions?
thanks