Formula syntax problem

krazykasper

Registered User.
Local time
Today, 11:19
Joined
Feb 6, 2007
Messages
35
I'm trying to set a formula in my report (Crystal 2003) to show that when a date is greater then or equal to 1/1/2009 OR if the field is NULL to print "LSE" else print "NOT". I'm having trouble with the following formula as it doesn't like the ISNULL:

IF {LeaseMaster.LeaseDispositionDate} >= DateTime (2009, 01, 01, 00, 00, 00)
OR {LeaseMaster.LeaseDispositionDate} ISNULL
THEN "LSE"
ELSE "NOT"

Appreciate any assistance.

Krazy (Bill) Kasper
 
I believe it should be:

Code:
IF {LeaseMaster.LeaseDispositionDate} >= DateTime (2009, 01, 01, 00, 00, 00)
OR IsNull({LeaseMaster.LeaseDispositionDate})
THEN "LSE"
ELSE "NOT";
 

Users who are viewing this thread

Back
Top Bottom