Are you quering a database that you upsized from VFP to SQL Server?

SQL Server only have datetime fields (but not date fields.) All your VFP date fields will be migrated to "datetime". But, since VFP does not know what "time" to post to these datetime fields it posts "12:00AM" by default.

>why do I always get 12:00AM from an SQLServer 7 datetime field ?