Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

date problems using vfp7 tables

Status
Not open for further replies.

dakotafox

Programmer
Apr 14, 2000
53
US
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.
 
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top