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