Hi All,

Crystal reports is showing empty/blank date fields as having a value of 12/30/1899.

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.

Also the ODBC connection is with the Microsoft Visual FoxPro driver and the "null" box under options is not checked.

Any advice would be greatly appreciated.

Jim Harvey
jharvey@netrax.net