Suppress on null date 1

[RobHVB6Sql]

I need to suppress a section when a date field is null.
These do not work:

Isnull({q1stContact-Numbers.DateOfFirstContact})
or
{q1stContact-Numbers.DateOfFirstContact} = Date(0,0,0)

Any suggestions? Rob Hasard
Data Manager -Genetic Services
(VB6 /SQL 7.0)

 

[synapsevampire]

This depends on your database, it may not have nor allow for nulls.

If the date is truly a null, Crystals' isnull() works against it (assuming a SQL Server database).

Try using an insanity check against the date, such as:

{q1stContact-Numbers.DateOfFirstContact} < currentdate-30000

Often times the date will have a default.

Use Query Analyzer to inspect the data.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com