>Dear All,
>
>I want to store a blank date in SQL. Whenever I store blank date. It stores as 01/01/1900. How to get rid of this problem. Or suggest me any other way of going about it.
>
>Thanks and regards,
Yes, it works, like you have described.
Write null instead of blank
Use isnull ms sql function to make queries for date fileds with potentionally blank dates
for example
sqlexec(con,'select isnull(dt,convert(
or use nvl on client side
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.
