[RESOLVED] Date Equals Null

[callydata]

How do I write: If Ending date = Null then do some stuff....
This is in Crystal syntax
Here is the code I tried but its not correct.

If {PAYABLES_TRANSACTION.Starting} < CurrentDate And
{PAYABLES_TRANSACTION.Ending} = CDate ("Null") Then
"$" + {PAYABLES_TRANSACTION.Amount} + " is paid to " + {PAYABLES.PayableCompany} + {@period1} + " begining on " + ToText({PAYABLES_TRANSACTION.Starting}) + " and will continue until paid in full."

- cally

[brucevde]

You need to use the IsNull function

If {PAYABLES_TRANSACTION.Starting} < CurrentDate And
IsNull ({PAYABLES_TRANSACTION.Ending}) Then