>I actually think it would be nice if the customer had SQL Server 2008. I understand that this version has Date type field and I would not have to always convert from DateTime to Date when working in VFP and SQL Server 2005.

In order to use SQL Server 2008 Date data type, you have to access it with SQL Server 2008 Native client but it doesn't work well with VFP.