Date printing problem

[AcnA]

Hello there,
I am having a problem with a report. I have a table with a date field on it. When that field has a date the report prints without any problem, but when that field is empty Crystal Report prints a dummy date instead of empty.
Anyone having a glue?

Thanx

 

[Madawc]

Test isnull{your.datefield} before doing anything else. Though I'm surprised you get a false date, on Crystal 8.5 one would get nothing.

I'm assuming that &quot;field is empty&quot; means null. If it were zeros, that might be seen as a date. In that case you could check your.datefield < date(1900, 1, 1) or whatever the possible limit is on your database.

Madawc Williams
East Anglia
Great Britain

 

[AcnA]

Madawc thanx. It seemed that the problem was the validation of the date (.field<date(1900,1,-1))

Thanx for the help