Cannot display null dates in Crystal Reports

[dougconran]

I am using the version of Crystal Reports that comes with Visual Studio 2003 which I think is v9.

I have a table in an access database (Jet 4.0) which has 4 records one of which has a date in a date column the others are blank.

I cannot display the 3 records with the blank date cells. I've tried all variations of null, < ,> ,<> that I can think of, each with and without the 'Convert NULL field Value to Default' option set.

I can display the one record with the date but, under no circumstances, can I display just the 3 without a date.

The date is 31/03/05, I've tried {date} > 30/03/05, this displays the one record but when I try {date} < 30/03/05 - nothing. I've also tried everything else that I can think of.

Does Crystal Reports enable reporting on null dates (or any other field types for that matter) or is this a cunning feature to save Brazilian rain forests?

I'm getting really frustrated here - any help would be much appreciated.

TIA

Doug

 

[vidru]

If you want to see results based on a Date field, but you want the NULL dates as well, you'd need to use the IsNull function to test:

IsNull({Table.Date}) or {Table.Date} = CurrentDate

A NULL value isn't less than, greater than, or equal to anything - it means that it's unspecified, or doesn't exist.

-dave

 

[dougconran]

Thanks for this - I had already tried this once, but tried it again and discovered that I had not unchecked 'Convert Null Fields to Default Value'.

At last, it works!

Many thanks

Doug