Dates Displayed through ODA driver

[GregCotten]

I had a problem this morning with Crystal Reports 8.5 running a JDE report going through the ODA driver. The particular field had null dates and was displaying as 12/31/1899. I checked the check box in Report/Options for Null fields with no avail. What I had to do was create a formula that changed the Date field to text and check it for the date. If it had the date then print a " ", else print the date. If you run into this problem use the following:

If ToText(Date):= "12/31/1899" then " " else (Date)

 

[Den32]

I am extremely new to Crystal. When I used your code I got the error message: "The keyword 'then' is missing." I type the code as you stated and by replacing the both (Date)'s with ({table.field}), neither with any luck. I was placing the code in the formula box under the selection expert as I did not find any other place for a formula. I am using Crystal v10 to access Visual FoxPro tables through an ODBC(RDO). Any suggestions you might have would be appreciated.