Need to check for null

[lbunch]

I am check for Past Due and Expired in teh @status field but what do I add for a check if there is not Past Due or Expired and @status is null. I am using Crystal 10 and @status is a date field... Thanks


If{@Status} = 'Past Due' then
{table.DOC2DDATE}
else if
{@Status} = 'Expired' then
{table.DOC2EDATE}

 

[Madawc]

if not isnull(@status).


Always test for nulls first, because Crystal stops when it hits a null for any ordinary command.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbunch]

I added the below but getting error "string is required"

If isnull {@Status} then
""
else

 

[lbass]

If the date field is of date datatype, then you would use:

if isnull({@Status}) then date(0,0,0) else
if {@Status} = 'Past Due' then
{table.DOC2DDATE} else
if {@Status} = 'Expired' then
{table.DOC2EDATE}

-LB

 

[lbunch]

Thanks - that works