Blank Date field not printing as blank

[APS]

Help

I have a Crystal Report in version 7 that uses a VFP 6.0 Database, and I have a date field on the report. If the date field in a record is blank in my database, Crystal is filling it in with 12/30/1899. WHY! I tried suppressing it with the isnull command but that does not work it still displays the 12/30/1899. If I browse the field data it has 12/30/1899 for the records that are blank

Help? [sig][/sig]

 

[MalcolmW]

Weird - does VFP support a true NULL value for dates, or is it just some bogus date value? Anyway, you could check out the following
File|Options|Reporting|Convert NULL Field Value to Default
Maybe changing the status of that would help.
[sig][/sig]

 

[kenhamady]

I suspect Malcolm is right about the default value added by Crystal.

But, changing it in File Options will only effect the next report you create. For any existing reports you need to make the change in File - Report Options.

[sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]

 

[APS]

Thanks

VFP uses an empty function which would work like the null function. Changing the report option did not help. Anyway I found a way around the problem. I created a formula field with the following if then statement.
IF {VFP field} = Date(1899,12,30) then
Date(0,0,0) else
{VFP field}


Again thanks for the help.
[sig][/sig]