>Hi!
>
>SQL Server does not have empty date value, as well as no dates less than mentioned date.
>To solve your problem, use .NULL. value in the field as empty date.
>
>>I am using a parameterized remote view from a VFP table. I used the MS VFP driver to set up the connection. When I initilize the parameters & do a requery on the view all the empty date fields come over as 12/30/1899. I tried to search the threads and only came up with one person who got 01/01/1899 from an SQL query and no listed solution.
>>
>>I am confused as to what to do to correct this. (and where did they get such a wack date from)
>>
>>Thanks in advance
>>
>>Terry
Thanks for the reply Vlad

I tried an experiment and made the view local. Guess what - the dates came over fine. Remade the remote view & 12/30/1899 again. VERY strange!!

Does this mean that I can't use SQL SELECT * ... format and must make special IIF functions for each of my date fields? Not very elegant.

Also, I got a reply from Bob Evans pointing to an Integer date system that would display -1 as 12/30/1899. Do you think the VFP ODBC driver does this?


Thanks again for your help. Your comments are always of great use.

Terry