[RESOLVED] Date Equals Null

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.

Quote:

---

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

You need to use the IsNull function

Code:

---

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

---