date problems using vfp7 tables

[dakotafox]

As a new user of Crystal Reports I am experiencing problems with date fields when working with a VFP7 table. If the date field contains a valid date value no problem, but if date field is empty it is reported/displayed as 12/30/1899 and then when the report is exported to Excel the same date field value is displayed in Excel as 01/00/1900. What formula syntax would identifiy this problem and correct the display?

Thanks for the assistance.

 

[dgillz]

Under file, report options, make sure the "convert null field values to default" checkbox is NOT checked. That will change this for this one report only.

If you do the same under file-options, all future reports will have the same properties and will leave a null field null and not populate it with some default value like you have described. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[dakotafox]

Thank you for the suggestion, but the checkbox is NOT checked in either option. As a test I checked the box and ran the report again and got the same results.