Hi Mindy!

I hope all is going well for you all in Lewisburg. How was your cruise?

I know you are using FoxPro data and the problem is null dates come through as 12/10/1899. The only thing you can do is loop through the records in the dataset and replace the values with DBNull.Value like the following code:

DateTime dtFoxProNull = DateTime.Parse("12/30/1899");
foreach (DataRow dr in ds.Tables["MyTable"].Rows)
{
  if (DateTime.Parse(dr["theColumn"].ToString()) == dtFoxProNull)
     dr["theColumn"] = DBNull.Value;
]
ds.AcceptChanges;

>I can display a valid check date in the CheckDate field in my grid, however, if the check date is null, my grid is displaying a generic date of 12/30/1899. Why? Can I see a blank field if there is no check date? Once I assign a valid check date to a particular transaction, it overrides the generic date of 12/30/1899 to display the correct date. I need to see NULL dates!