Crystal Report Date Problem with VFP table

[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?

Also the "convert null field values to default" checkbox is NOT checked.

Thank you in advance for the assistance

 

[rogar]

I'm guessing your database actually stores the date value "12/30/1899" to represent a null date (it could be a numeric zero, as the starting point of its internal date representation). One way to handle this is with a formula on the order of "if {date} = '12/30/1899' then "" else totext({date}) You will have to convert the date to text so that both parts of the if..then..else are the same type.
You may have to experiment to get the punctuation right.