>I'm using remote views in my client application to access a vfp database on a remote server. These remote views are updatable. Once in a while, for some reason I still haven't figured out, one of the date fields' values get changed to {12/31/1899}. Can anyone give me a hint what's happening here?
>
>Thanks a million to anyone who will take the time to reply. My application is a scheduler system so date is everything!
>
>Again, thanks!
Jet,
SQL server wouldn't accept empty dates but nulls only (if field is set to accept null). An empty date would be forced to {12/31/1899 12:00 AM}
Set you field to accept nulls. So you can have nulls for not enetered date,datetime values.
Cetin