SQL server does not permit empty datetime fields values, only nulls
Blank date is substituted at the bigining of the sentury
Set allow null
It will be null instead of empty
Use in VFP set nulldisplay for example to hide nulls on isnull(,) ms sql function ( equivalent of VFP nvl) to make query for remote datata
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.