>Hi All,
>
>Crystal reports is showing empty/blank date fields as having a value of 12/30/1899.
The foxpro ODBC driver converts empty dates to 12/30/1899 because there is no concept of empty dates in ODBC.
>
>I can't create a fox2x type file for the user to report on and therefore I am forced into using ODBC.
>
>Has anyone come up with a procedure to show empty/blank dates in a report.
>
>I'm trying to create a formula field "mdatefoal" with something like this:
>
>IIF (isnull({MASTER.DATE_FOAL}),(" "),{MASTER.DATE_FOAL}) but can't seem to get it right.
The blank date and the Null date are not the same. You will get Null date thru ODBC only if you allow null in the date field in foxpro and replace empty dates with nulls.
>
>Also the ODBC connection is with the Microsoft Visual FoxPro driver and the "null" box under options is not checked.
This affects only INSERT command. If you set Null ON, INSERT – SQL inserts a null value into any column not included in an INSERT – SQL… VALUE clause. A blank is inserted if Null is OFF.
>
>Any advice would be greatly appreciated.
>
>Jim Harvey
>
jharvey@netrax.net
--sb--