Correct syntax for not null

[shaleen7]

I want to include any fields that are not null
in my query.

But the following syntax does not work:
isnotnull({TABLE.DATE})

Any suggestions?

 

[lbass]

The correct syntax is:

not isnull({table.date})

If this doesn't work, you could try:

not (isnull({table.date})) or
{table.date} <> date(0,0,0)

-LB

 

[shaleen7]

Many thanks

 

[synapsevampire]

If you want to remove ROWS (not fields) if a certain FIELD (column) is null, use Report->Edit Selection Formula->Record

and place something like:

not isnull({table.field})

If that field is NULL (not zero or blank), then the entire row will be eliminated.

-k