I am hoping some of you sharp VFP people have Crystal Reports experience.
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?
The normal VFP date converions do not work.
Thanks for the assistance.
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?
The normal VFP date converions do not work.
Thanks for the assistance.
